[thelist] Using Firebird as an embedded database

[Peter Brunone (EasyListBox.com)]

I'm rather curious about the need for an embedded database that needs to perform like a database server.

 From: Keith Gaughan keith at digital-crew.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Joshua Olson wrote:

> Unless you've tried MSDE and it failed, I'd suggest you give it a try. It
> can handle a HUGE number of simultaneous connections, much like its big
> brother.

I use MSDE quite a bit, but it's main sticking point is...

> The bottleneck is introduced while doing simultaneous accesses to
> the database. However, it's not a strict limitation in that accesses above
> and beyond the limit (10) are locked... it's a soft limitation in that
> accesses above and beyond the limit are slowed down. Depending on the speed
> of the hardware, you may never even find this to be a problem.

That's one of my two problems with it. That, and it's Windows only, and
these need to run on both Windows and some Unix-like OS, be it OSX,
Linux, AIX, or whatever.

K.