Thanks for the heads up Helen. I'll have to check if this caused one of my more mysterious test failures last week and review the docs you suggested.


Sounds as if you are all in the AutoCommit trap. AutoCommit uses
CommitRetaining, which traps the garbage from updates and deletes in an
ever-accumulating heap until the door just won't open.

It's not IB or Firebird or IBO that causes your "freezing" problems - it's
lack of programmer attention to moving the OIT forward and freeing up
obsolete record versions so they can be garbage-collected and made eligible
for sweeping.

IBO has techniques for making transactions behave properly wrt
OIT. Unfortunately, it doesn't have any built-in magic to kick your butt
if you choose to ignore them. This question belongs in the IBO list and
the solutions (several) are to be found in the on-line documentation and
the help files.

/heLen


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]