Subject | Re: Memory use and FB 1.5 |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-06-30T10:42:37Z |
> We'll need a bit more information. Can you give us the statisticsof
> the database? Use GSTAT.exe to retrieve the database header, whichDatabase "E:\Db\Kaufmann\OCCEasyPos.Gdb"
> contains the statistics and some other useful information. Try to
> get that information before you do the backup and restore.
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 ?
>I did a commit after each 50 inserts.
> 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?
Michael