OIT/OAT is ok, the difference is allways 1. As I wrote in my first
post the transaction logic of my application is ok.

--- In firebird-support@yahoogroups.com, "diwic2" <diwic2@...> wrote:
>
> Is the OIT/OAT increasing as the updates go? If not, you have missed
> an open transaction. Running gstat upon your db will tell you the
> values of the "Oldest Interesting Transaction".
>
> // David
>
> --- In firebird-support@yahoogroups.com, "michel_messner" <Messner@
> > wrote:
> >
> > Hi,
> > I'm using firebird 1.5.2.4731 with a local connection. In my
> database
> > I have a quite big table with about 200 fields. There are not many
> > rows in the table(200-2000). But I'm updating the same dataset very
> > often. After 30000-50000 Updates Firebird starts to catch a lot of
> > memory and causes Win XP Professional(SP2) to swap to the pagefile.
> > During that 30-50seconds XP and Firebird is not responding anymore.
> > What can I Do to prevent that.
> > My transactions are very short and the logic is also ok.
> > Sweep-interval is set to 0.
> > I allready tried to do a select on that record every 100 updates,
> but
> > this didn't help.
> > Sometimes when I validate the database with gfix there are many
> > orphans in that table.
> >
> > Has someone a solution for that problem?
> >
>