Subject Oldest snapshot issue.
Author btrewern
Hi all,

For some time I've been having an issue with one of our applications
running slower and slower over time. When I do a gstat -h on the
database I get:

Database header page information:
Flags 0
Checksum 12345
Generation 242484
Page size 4096
ODS version 11.0
Oldest transaction 150533
Oldest active 150534
Oldest snapshot 150300
Next transaction 242477
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 3, 2008 7:46:43
Attributes force write

Variable header data:
Sweep interval: 20000

I'm not sure how to read the above but it looks like there is
something keeping a snapshot open over 9000 transactions ago. Is this

This application should be mainly read only with no long running
transactions. I'm using the Delphi and the BDE to access Firebird.
What would be the best way to debug this issue.

BTW I'm using Firebird 2.0.4 on windows 2000 server.