Subject Re: [firebird-support] Updating/Inserting is slower and slower
Author Helen Borrie
At 07:22 AM 9/10/2003 +0000, you wrote:
>I have an application that update/insert to firebird database. It is
>running slower and slower from the number of record it update and the
>time use from my application log file. I have no idea how to check on
>the database as I can't find any error in the interbase.log. What I
>have done is backup the database and hoping it will improve the
>performance. does anyone have any idea why is it slow, how to check
>on the database performance and improve the performance ?
>The firebird version is S0-V6.2.796 Firebird 1.0 running at Sun
>Please advise.

That symptom usually indicates that there is not enough committing going
on. Back-versions build up and build up until things grind to a halt and
even crash the server sometimes.

For a rough idea of what's happening, use SHOW DATABASE in isql. The thing
to pay attention to is the gap between "Transaction - oldest" and
"Transaction - next". As a guideline, the gap should be approximately
equal to the number of active users (or less). Watch that gap - if you see
the db slowing down at a similar rate to the growth of the gap, then you
have your answer.

Huge bulk deletes can cause a buildup of back versions too.