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?
>