Subject | Re: FW: [firebird-support] database of 9mb is extremely slow! ref/eDN8022297953 |
---|---|
Author | Ann W. Harrison |
Post date | 2007-12-20T17:03:33Z |
dennis wrote:
in the database. I think the switches are -a -r. I've
explained how to read it several times over the past couple
of years. Look for long chains of back versions.
Good luck,
Ann
>Those look OK. Gstat also produces a report of space usage
>
> Oldest transaction 3,035,196 <<<
> Oldest active 3,051,658 <<<
> Oldest snapshot 3,051,415 <<<
> Next transaction 3,051,680 <<<
in the database. I think the switches are -a -r. I've
explained how to read it several times over the past couple
of years. Look for long chains of back versions.
Good luck,
Ann