> At 08:09 a.m. 19/03/2015, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] wrote: > >>Ask your software vendor to fix their client transaction management. >>Using auto commit as default transaction management mechanism is >>Firebird's enemy number 1. Not only due to OAT not moving forward, you >>may also reach the 32-bit transaction id limit, depending on your load, >>in weeks/months until a backup/restore cycle is mandatory. > > It is not AutoCommit, per se, that prevents the OAT from moving forward, but > another transaction setting, COMMIT WITH RETAIN.
Yep. What I wanted to say is that AutoCommit of access components internally usually implies using commit retaining. Didn't make that clear enough in my reply. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Assuming your software is > written with Delphi or a derivative, the setting is called CommitRetaining. > The hangup can be cleared if the software also periodically performs a hard > COMMIT on the offending set. This isn't something you can fix yourself, if > you > don't have access to the source of the client code. Thomas' comments stand > true, regarding AutoCommit eating up the transaction count. > > There may be another flaw in the transaction management: if a set is being > used > for display and select but not for writing - such as in a drill-down scenario > or a lookup - that runs throughout the user session in a read/write > transaction with ReadCommitted visibility, then this will hold the OAT back as > well. When such sets run in a read-only transaction, they do not cause the > OAT > to get stuck. Again, this is for the software vendor to fix. > > > Helen Borrie, Support Consultant, IBPhoenix (Pacific) > Author of "The Firebird Book" and "The Firebird Book Second Edition" > http://www.firebird-books.net > __________________________________________________________________ > > > > ------------------------------------ > Posted by: Helen Borrie <hele...@iinet.net.au> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > >