Steve,

> I have recently gone through the TIB_Transaction.TimeoutProps options. I found the documentation a bit opaque. I have tried to document them in a way that makes sense to me. Would you please take a quick look at the document and tell me if my interpretation matches reality? Any suggestions are appreciated. Firebird transaction management seems to be one of the most important and least understood subjects.

Yep. I can tell you stories from consulting gigs. Really. ;-)

> Once completed, I will leave this available for others to reference.
>
> http://www.lnssoftware.ca/blog/?p=141#more-141

One thing is, if you only read data, then use a read-only transaction.
In combination with the read committed isolation level, you are in a
transaction mode with very low overhead and OIT/OAT won't get stuck as
well, even for long runners.

Use some kind of tracing to figure out what's exactly going on. Either
with IBO's stuff or if you are on Firebird 2.5, then get used to the
Trace API. An invaluable feature. And even better, give our FB
TraceManager product a try. ;-))



--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/