Subject Long Running Transactions
Author Pierre Y.

Are the advices concerning Long Running Transaction, posted by Craig Stuntz
in his blog, applicable to Firebird ?

Understanding Transaction Lifetime :

Practical Use of Long Running Transactions :

In short :

For read only long running transactions : isc_tpb_read_commited +
isc_tpb_read has no impact on Firebird server's performances.

For read write long running transactions : isc_tpb_read_commited + call to
CommitRetaining from time to time in order to help the server to reduce its

Best is to use long running READ ONLY transactions at Read Commited
isolation level + short read/write transaction at SNAPSHOT isolation level.


Pierre Y.