| Subject | same Update takes first 0 sec then 10 sec? |
|---|---|
| Author | Richard |
| Post date | 2003-07-28T14:10:55Z |
Another mystery for me.
this works fine:
UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
COMMIT;
But this:
UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
COMMIT;
the first update take hardly any time.
the second update takes about 10 to 14 sec.
I dont know why.
Validation show me no problems with changeinfo. Only orphan
backversions in an other table.
Richard
this works fine:
UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
COMMIT;
But this:
UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
COMMIT;
the first update take hardly any time.
the second update takes about 10 to 14 sec.
I dont know why.
Validation show me no problems with changeinfo. Only orphan
backversions in an other table.
Richard