Subject Re: [firebird-support] Re: 1.8Gb database performance issues
Author Michael Weissenbacher
Hi,
> Page size 4096
> ODS version 10.1
> Oldest transaction 123867
> Oldest active 135048
> Oldest snapshot 129882
> Next transaction 144569
> Bumped transaction 1
That gap seems pretty big for me. If you don't have a good reason for
long-running transactions you should look into that problem. In the
meantime (as an intermediate fix) you could do a daily shutdown and
sweep of the database, or even a periodic backuprestore cycle.

Michael