[thelist] Using Firebird as an embedded database

[Joshua Olson]

> -----Original Message-----
> From: Keith Gaughan
> Sent: Thursday, June 23, 2005 12:52 PM
> 
> We've a few projects here where we'll need some kind of an embedded
> DBMS. It'd be nice to avoid MySQL (because of the need for a 
> commercial license), MSSQL (as it's Windows only and its embeddable
> form--MSDE--doesn't allow as many simultaneous connections as 
> we'd need in a server environment)

Keith,

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.  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.

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 
Fax: 413.812.4864

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/