Hi,
can you confirm, that Virtual RAM allocated by Firebird exactly?
did you analysed Proccess/Thread, CPU, DISK I/O activities via the
Task Manager?
Is not it any side effect of any other program?
Whats is your disk definations?
if you have dupplicate indices and you will have alot of record
versions too because of sweep disabled. This cause preformance
disaster.

Ali

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