Subject Re: [firebird-support] how to find the bottleneck or slow queries/triggers/stored procedures
Author Alexandre Benson Smith
Helen Borrie wrote:
> ...which you didn't quite understand, methinks...while it's true that
> they have not restored their database for 20 months, that does not
> cause "27 million transactions to pile up". Transactions don't "pile
> up" and their system isn't "piling up" anything. Long-running
> transactions cause obsolete record versions to "pile up" (garbage,
> that is). But their application code is taking very good care of
> transactions, in fact these statistics are as close to "perfect" as I
> have ever seen in a production database.
> ./heLen
>

Perhaps, the gstat was executed without a connected user ? or right
after they start using it ? :)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br