| Subject | firebird allocates suddenly a lot of memory and causes XP to swap |
|---|---|
| Author | michel_messner |
| Post date | 2006-03-09T10:39:44Z |
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?
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?