Subject Re: Memory use and FB 1.5
Author Michael Vilhelmsen
> 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.




Database "E:\Db\Kaufmann\OCCEasyPos.Gdb"

Database header page information:
Flags 0
Checksum 12345
Generation 293622
Page size 4096
ODS version 10.1
Oldest transaction 285658
Oldest active 285659
Oldest snapshot 284791
Next transaction 293615
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jun 21, 2004 23:15:25
Attributes force write

Variable header data:
Sweep interval: 20000
*END*


Is this what you were asking for ?


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

I did a commit after each 50 inserts.

Michael