> Hi,
>
>>is it better to have one connection with multiple transactions or
>>multiple connections with one transaction per connection ?
>>I am writing a multi-threaded server application, which will have 4 to ?
>>connections or transactions. How many transactions per connection are
>>possible ?
>
>
> Firebird doesn't support multiple threads _concurrently_ using
> the same connection.

If you can't use multiple threads with multiple transactions, than the
feature of multiple transactions seems useless to me.
So you say, multiple transactions can only be used within one thread,
which accesses different tables in different transactions using the same
connection?

thx,
Stefan

>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &

MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com