Subject Re: [firebird-support] Embedded for MultiThread
Author Dean Harding
Kjell Rilbe wrote:
> 1. Embedded allows only one client instance (= "one single loading of
> the embedded driver") to connect to the server, but it can have any
> number of connections.

Well, the way I'd word that is that you can only have one process access
the database at a time but that one process can connect as many times as
it likes.

> 2. Connections should not be shared between threads, unless each use is
> protected with a critical section.

Yes, but you don't need to share connections between threads because you
can have as many connections as you like (one per thread, for example).

Typically, you'd use connection pooling to only open as many connections
are you need simultaneously. Depending on your programming language, it
probably already has connection pooling support built-in.

Dean.