Subject | Re: [firebird-support] Re: 1.8Gb database performance issues |
---|---|
Author | Michael Weissenbacher |
Post date | 2007-02-07T12:19:52Z |
Hi,
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
> Page size 4096That gap seems pretty big for me. If you don't have a good reason for
> ODS version 10.1
> Oldest transaction 123867
> Oldest active 135048
> Oldest snapshot 129882
> Next transaction 144569
> Bumped transaction 1
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