Hi,

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

Understanding Transaction Lifetime :

http://blogs.teamb.com/craigstuntz/articles/UnderstandingTransactionLifetime
s.aspx

Practical Use of Long Running Transactions :

http://blogs.teamb.com/craigstuntz/articles/PracticalUseOfLongRunningTransac
tions.aspx

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
overhead.

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

Regards,

Pierre Y.