Re: performance issue on delete record
Re: performance issue on delete record
- Subject: Re: performance issue on delete record
- From: Mike Schrag <email@hidden>
- Date: Fri, 21 Aug 2009 07:25:22 -0400
delete manually without EOF -- just execute that SQL yourself -- is it
still slow? this will tell you database vs eof.
ms
On Aug 21, 2009, at 6:55 AM, Shelley Eitzen wrote:
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
_______________________________________________
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