Hi group.
I've working around tuning up a database speed and found that gstat -h shows
valuable information about transactions. Also that gfix -sweep removes garbage
from the database.
I understood that when Next transaction grows too much from Oldest active
transaction, "sweeping" the database makes this difference become smaller.
But this is not the case with my database.
What am I doing wrong?
this is the gstat -h from the database:
*************************************************
Database "d:\med6\ibdata\sistmed6.fdb"
Gstat execution time Mon Jul 01 10:39:55 2019
Database header page information:
Flags 0
Checksum 12345
Generation 236628301
Page size 4096
ODS version 11.2
Oldest transaction 236413964
Oldest active 236413965
Oldest snapshot 236413965
Next transaction 236627938
Bumped transaction 1
Sequence number 0
Next attachment ID 31194
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Mar 24, 2018 10:27:14
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
*************************************************
Any help will be appreciated.
Regards,
Hernando.
