Hi Stefan,

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

Yes, for example in a GUI application, you can have multiple
datasets open, and keep them open while you save your data
by using another transaction.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com