Subject Firebird db statistics and performance
Author rogerpullen
Hi - can anyone comment on these db stats - I guess the transaction id's are not good with such a difference. The db is being abused somewhat with users not logging out at night hence the sweep we run (I assume) is having little effect. The consequence of all this is deteriorating perfomance that only a backup/restore can fix.

Database "e:\s32031\heesdata\hees_64.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 17624180
Page size 8192
ODS version 11.2
Oldest transaction 12940759
Oldest active 12940760
Oldest snapshot 12940760
Next transaction 17616636
Bumped transaction 1
Sequence number 0
Next attachment ID 9643
Implementation ID 26
Shadow count 0
Page buffers 20000
Next header page 0
Database dialect 1
Creation date Jun 5, 2013 0:13:43
Attributes force write

Variable header data:
Sweep interval: 0