Subject Re: [IBO] Server physical transactions and TIB_Transaction Auto-commit
Author Luciano Sparacino
IB server doesn't free memmory and my application turns extremely slow until
the ibserver is restarted.

Going back to the past (i mean keeping working with IBO3.3)... i'd like to
insist with my problem.

I've noticed that my application opens several transactions (about 250) for
small amount of data (tables that contains less than 20 rows). The fact is
that these datasets (most of them TIBOTable) have their property
IB_Transaction set to <default> and that causes the application to open
automatically one transaction for each open dataset.

is this amount of open transactions (which are never commited while the
application is running) a cause for the ibserver to start working slowly
after a couple of hours?

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <>
Sent: Wednesday, December 05, 2001 5:38 PM
Subject: Re: [IBO] Server physical transactions and TIB_Transaction

> You most likely have a transaction stuck.
> Back in those days (of IBO 3.3) there was the potential of a few things.
> What I suggest you do is put a general check by getting the session
> reference and then looping through all the session's Transaction[]
> references. You can look to see if any are being left open at a time when
> they shouldn't be.
> One remote possibility is the transaction for the SchemaCache may be
> things up. For a time this was a blind spot and you might be in that. My
> memory doesn't server me well enough to recall the exact versions of IBO
> this was a problem. In short, doing the general loop through the sessions
> global list of transactions will give you the "vision" you need to
> investigate your apps transaction hang-up problem.
> Keep this topic alive as necessary. This is a very important aspect.
> Jason Wharton
> CPS - Mesa AZ
> ----- Original Message -----
> From: "Luciano Sparacino" <lsparacino@...>
> To: <>
> Sent: Wednesday, December 05, 2001 1:07 PM
> Subject: [IBO] Server physical transactions and TIB_Transaction
> > HI!
> >
> > I'm having a problem with my client/server application and i don't
> know
> > where o attack it in order to find a solution. I'm actually working
> > IBO 3.3 and IB 6.0 on Winnt 4.0.
> >
> > The fact is that the server starts consuming more and more memmory
> > during the day up to a point in which it becomes very slow... the only
> thing
> > we can do then is to restart it and everithing works ok.
> >
> > I don't know if there's anything i can do with my IBO components to
> get
> > a better performance and release the load to the IB server (i'm actually
> > using TIBOQuery, TIBOTable, TIB_TransactionSingle and TIB_Connection)
> >
> > I read from a guy from MER systems that physical transactions do
> > memmory allocated since you prepare a Dataset and then that's only
> released
> > when commiting or rolling back. What happens if i have my transaction
> > as auto-committ?
> >
> > thnks
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to