performance issue on delete record
performance issue on delete record
- Subject: performance issue on delete record
- From: Shelley Eitzen <email@hidden>
- Date: Fri, 21 Aug 2009 20:25:17 +0930
Hi All,
WebObjects 5.3
Mac OSX 10.5.8
Openbase 11.0
we are having a performance issue when we delete a record.
application functionality is
delete record
create log record in another table
the delete works fine when there is less than 168763 records in the
table we are deleting from, but as soon as there is 168764 the delete
takes 6 MINUTES,
the editing context contains 1 deleted object, 1 inserted object and 2
updated objects, which are the same in both the transactions.
the time lag occurs during the editingContext.saveChanges() method
we use the openbase plugin to generate the primary keys and the openbase
simulation file shows the same sql is being executed and the primary
keys are being referenced.
Can anyone offer a direction on where to look?
Cheers
Shelley
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden