Wim,
We've used IB extensively for the past few years - it's an excellent
low-maintenance choice (DBA-free) for small to medium applications, but
doesn't scale well to large numbers of users or heavy loads. Depending on
the OS platform, there is a hard limit of 250 simultaneous connections - but
we often run into concurrency problems well below that number, even on large
Sun servers.
E-mail me if you need more info,
Steve
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of wim veninga
> Sent: 12 October 2000 18:53
> To: Orion-Interest
> Subject: Re: HARDWARE FOR J2EE apps
>
>
> Hi Kevin,
>
> Do you create the database in IBConsole ? Because the ibconsole
> has an bug when
> creating databases.
> If so, you probably have to get the newer version of IBConsole :
> URL : http://www.interbase.com/open/downloads/ib_download.html
> goto the miscellaneous section (at the bottumn of the page) and download
> IBConsole - build 308. You must overwrite the ibconsole in your interbase
> install directory. If you want the interbase-database-schema.xml
> (for orion cmp
> managed persistence) mail me and i will sent it to you.
>
> Further more i think interbase 6 is an very good database but I
> would like to
> know
> if it handle a large amount of connections at the same time (like 500 or
> something).
> There isn't much info about that in the docs.
>
> Greetings Wim Veninga.
>
>
>
> "Duffey, Kevin" wrote:
>
> > Hey Scott,
> >
> > Interbase 6 is pretty nice in my opinion. Its SQL 92 compliant (if that
> > means anything), its completely free and is now open-source,
> has a type IV
> > jdbc driver, and it has a VERY small foot-print. It runs on
> most platforms I
> > believe, and thus far its pretty darn fast. However, I have not
> been able to
> > successfully create a database in it. I keep getting some
> stupid error when
> > I try to create a database and I can't find any information on
> it. I'll have
> > to post to the Interbase site probably..or maybe there is a
> newer version. I
> > wish there was some more detailed info on how to completely set up
> > Interbase. I can however connect via my java app and get
> connections out. I
> > just can't seem to create tables and what not. Anyways..I worked with
> > Interbase 4 and it was pretty fast, so I am sure 6 is better in
> many ways
> > (that is not always true..but I hope it is).
> >
> > > -----Original Message-----
> > > From: Scott Stirling [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, October 11, 2000 3:25 PM
> > > To: Orion-Interest
> > > Subject: RE: HARDWARE FOR J2EE apps
> > >
> > >
> > > Why would you use mySQL over Postgresl? They're both free,
> > > but Postgresql has a
> > > JDBC driver that's XA-compliant. Also, mySQL is known to
> > > blow away your whole
> > > database if it has a bad crash, whereas Postgresql is better
> > > at persisting data
> > > through a bad crash.
> > >
> > > How does Interbase 6 compare to Postgresql? Is it free?
> > >
> > > Scott Stirling
> > > West Newton, MA
> > >
> > > > -----Original Message-----
> > > > From: [EMAIL PROTECTED]
> > > > [mailto:[EMAIL PROTECTED]]On Behalf Of
> > > Duffey, Kevin
> > > > Sent: Wednesday, October 11, 2000 4:01 PM
> > > > To: Orion-Interest
> > > > Subject: RE: HARDWARE FOR J2EE apps
> > > >
> > > >
> > > > Hi,
> > > >
> > > > > sounds very nice but what about the database? how do you
> > > cluster that
> > > > > without spending an arm and a leg? our experience is, that
> > > > > it's not that
> > > > > hard to set up clustered web services with static pages and
> > > > > servlets but
> > > > > the really expensive part is, when you want that high
> > > > > availability for your
> > > > > database. it doesn't buy you much if you have highly
> > > > > available ejbs when
> > > > > the database server goes down. many people use clustered
> > > > > apache/jserv on
> > > > > linux and cheap pc-hardware for high volume transactional
> > > > > websites but have
> > > > > a large enterprise sun running oracle in the back. anyone out
> > > > > there running
> > > > > a configuration with orion that includes a database with
> > > > > failover that
> > > > > doesn't blow up the budget too much (compared to other
> > > components)?
> > > >
> > > > Well, to start off with there is mySQL and the one I like
> > > the most is
> > > > Interbase 6..a free powerful RDBMS. However, as far as
> > > clustering them..I
> > > > don't quite know the best way. I would think a
> > > load-balancer or a switch or
> > > > something, would be required. Nobody ever said it was
> > > cheap! ;) I used to
> > > > think $25,000 could easily set up a website from front to
> > > back, software,
> > > > hardware, etc..but not even close these days. If you are
> > > just starting out,
> > > > I would use Orion for front-end and ejb-logic tiers in a clustered
> > > > environment (for developing/testing), with a single server
> > > running mySQL or
> > > > Interbase for the database. Once you get some funding and
> > > move beyond the
> > > > concept phase, you should put a sizeable chunk to invest in
> > > co-locating your
> > > > site and doing the full load-balancing setup. I would
> > > estimate a cheap setup
> > > > with 2 front-end web/servlet servers failed over, 2 ejb
> > > servers, and a
> > > > database cluster will still run around $100,000, to co-lo
> > > it..which is
> > > > probably the best thing to do to make sure its up 24/7.
> > > >
> > > >
> > >
> > >
>
