Subject updates getting slower and slower
Author lutz_mueller2003
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?

lutz mueller