Subject RE: [firebird-support] Embedded for MultiThread
Author Alan McDonald
> Dear All ...
>
> I need to develop an embeded system that have db capabilities.
> this one will be in MiniITX box with only 1 GB CF and up-to 1 GB RAM.
>
> I'm looking for small footprint SQL solution ... and I read about this
> FireBird embedded.
>
> I knew that in FireBird-Embedded .. database can onlly be use by one
> application at a time ... caused by it's locking scheme.
>
> I read about it from what heLen said at
> http://tech.groups.yahoo.com/group/firebird-support/message/96637 ,
> but what about an application that generate multi thread (i.e :
> application that act as TCP/UDP server and fork new thread for every
> request) ? will that Threads allowed to access the db in the same time
> ?
>
> How big is FireBird installation as "server" ?
>
> Sincerely
> -bino-

Multiple threads can use the same connection so there is no impediment
there.
The embedded server (including client) is 2.6Mb, The client only is ~500Kb
The full server install is 25Mb including documents

Alan