Subject Re: High volume of INSERT/DELETE operations
Author Doychin Bondzhev
> How did you do it?

I traced the execution of the code.

> Could you show transaction statistic of your
> database (gstat -h)?

Database header page information:
Flags 0
Checksum 12345
Generation 92727
Page size 8192
ODS version 11.1
Oldest transaction 92693
Oldest active 18656
Oldest snapshot 18656
Next transaction 92694
Bumped transaction 1
Sequence number 0
Next attachment ID 20
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 16, 2008 8:34:11

Variable header data:
Sweep interval: 200

> Sweep is not garbage collection (though may trigger it). I'd rather
> suggest to play with GCPolicy configuration parameter...

GCPolicy is not an option because I'm using Classic server.