Subject | Re: [firebird-support] how to find the bottleneck or slow queries/triggers/stored procedures |
---|---|
Author | Alexandre Benson Smith |
Post date | 2008-08-18T15:42:22Z |
Helen Borrie wrote:
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
> ...which you didn't quite understand, methinks...while it's true thatPerhaps, the gstat was executed without a connected user ? or right
> 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
>
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