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@...]
>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