Sorry, I don't know these topics. Gstats doesn't returns something
different or I don't call it correctly.

Anyway, something else, with backup restore without backuping the garbages
the database it works perfect. Can we to this "garbage delete" with more
easy way except the backup and restore way?

In general, we have customers with databases of 5 & 6 gb. Till now we do
backup and restore for maintenance. Is there anything else to do more
professional?



Regards Dennis



p.s. I go for rest, I will read your emails tomorrow. Thank you all guys!





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Thursday, December 20, 2007 7:04 PM
To: firebird-support@yahoogroups.com
Subject: Re: FW: [firebird-support] database of 9mb is extremely slow!
ref/eDN8022297953



dennis wrote:

>
>
> Oldest transaction 3,035,196 <<<
> Oldest active 3,051,658 <<<
> Oldest snapshot 3,051,415 <<<
> Next transaction 3,051,680 <<<

Those look OK. Gstat also produces a report of space usage
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





[Non-text portions of this message have been removed]