Subject | Re: [firebird-support] Memory use and FB 1.5 |
---|---|
Author | Daniel Rail |
Post date | 2004-06-30T10:38Z |
Hi,
At June 30, 2004, 06:06, Michael Vilhelmsen wrote:
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)
At June 30, 2004, 06:06, Michael Vilhelmsen wrote:
> To night I will do a backup - restore to see if it will solveWe'll need a bit more information. Can you give us the statistics of
> anything.
> But I would like to know why this has happen.
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)