Re: performance issue on delete record
Re: performance issue on delete record
- Subject: Re: performance issue on delete record
- From: Chuck Hill <email@hidden>
- Date: Fri, 21 Aug 2009 09:17:04 -0700
On Aug 21, 2009, at 3: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?
You have verified that the exact same SQL statements are issued each
time? Based on that slim evidence, I'd suspect the database. Deletes
should only be a problem in EOF if you are triggering off a lot of
delete rules (cascading) or firing off the faults for a large inverse
relationship.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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