updates extremely slow

[Arne Gehlhaar]

Hi,

there is an effect with SAP DB 7.3.0.29 which I don't understand. I have several tasks doing simultaneous inserts, selects and updates on one table (~45000 rows) with standard isolation level (committed). The inserts run very quickly but the updates are extremely slow. The update statements are very simple: "UPDATE table SET column=value1 WHERE table.primarykey=value2". They are all carried out in one transaction.

When I do "SELECT * FROM lockstatistics" a number of times I can see the number of locks slowly increasing. The locks all belong to that one update job, so I guess there are no collisions.

Is there anything I can do (WITH LOCK XYZ on select statements, etc.) that will speed up the update statements?

Arne

--
Institute of Shipping Economics and Logistics http://www.isl.org/
Arne Gehlhaar mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A phone:+49.421.22096.49
D-28359 Bremen, Germany fax:+49.421.22096.55

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general