Subject Re: [firebird-support] updates getting slower and slower
Author Helen Borrie
At 10:05 AM 25/10/2004 +0000, you wrote:

>i have a table with only 1 record. i run updates like "update
>field=field+? where pk_id=?" on this record. the updates are
>executed by one process, and come in transactions which include
>about 1000 updates. while the first transaction takes about 1.5sec
>the 100. transactions takes up to 15sec. and it gets slower and
>slower. what could be the reason for this ? my first guess was the
>mga , but there are no concurrent transactions, since the statements
>are executed sequentially by just one process. does anybody know
>what is causing this decrease in performance?

"update field=field+? where pk_id=?" isn't a valid statement. Show us the
actual update statement.

And clarify - are you performing 1000 updates on the same record in a
single transaction? If yes, then the next question is: why?