Subject Re: [firebird-support] Multiple concurrent commands on same connection?
Author Helen Borrie
At 12:40 AM 20/06/2010, you wrote:
>I'm using Embedded Firebird server from my application (1 process).
>Does it work to run multiple concurrent commands all using same
>connection to my database?
>Will there be any problem doing this?

It all depends on what you mean by "multiple concurrent commands".

Embedded runs in the application space and only one application instance can be connected. If you run a second application instance, it won't be able to connect until the first instance disconnects.

Within a connection there can be many transactions; and each transaction can make multiple SQL requests. Concurrency of requests is determined by the transaction settings.