Subject Re: [firebird-support] Memory use and FB 1.5
Author Daniel Rail
Hi,

At June 30, 2004, 06:06, Michael Vilhelmsen wrote:

> To night I will do a backup - restore to see if it will solve
> anything.


> But I would like to know why this has happen.

We'll need a bit more information. Can you give us the statistics of
the database? Use GSTAT.exe to retrieve the database header, which
contains the statistics and some other useful information. Try to
get that information before you do the backup and restore.

My suspicion is that it might be related to garbage collection,
because of the high number of records that you inserted. Did you do
the insert within one single transaction or did you commit after a
certain amount of records?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)