Thanks for a straightforward answer. I am on my way to IBO. Sorry
this question was posted in the wrong spot - it is hard to know where
these problems occur without knowing more about the technology.




--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 01:14 PM 3/02/2004 -0500, you wrote:


> >We used to get that behavior with IB5.5 and IBO. We quit using

both a few

> >years ago and I don't remember that problem occurring since then.


> >


> >-----Original Message-----


> >From: georgethenorge [mailto:ghelmke@o...]


> >Sent: Tuesday, February 03, 2004 4:13 AM


> >To: firebird-support@yahoogroups.com


> >Subject: [firebird-support] Re: Whole System Freezes


> >


> >


> >I am getting EXACTLY this problem with FB1.03 running RH73, and am


> >trying to find out why. I am using IB_Objects for the client app,

are

> >you?


>


> 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