| Subject | Re: [firebird-support] Updating/Inserting is slower and slower |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-10-09T07:59:31Z |
At 07:22 AM 9/10/2003 +0000, you wrote:
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.
heLen
>hi,That symptom usually indicates that there is not enough committing going
>
>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
>machine.
>
>Please advise.
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.
heLen