Re: performance issue on delete record
Re: performance issue on delete record
- Subject: Re: performance issue on delete record
- From: Shelley Eitzen <email@hidden>
- Date: Thu, 27 Aug 2009 09:29:12 +0930
Chuck Hill wrote:
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
Definately executing the same sql. Below is a snippet from the openbase
logs
Any other suggestions?
Cheers
Shelley
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
no delete issue:
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//THREAD_0x214a50:272543600.874695:2009-08-21 20:03:20 +0930
//THREADS RUNNING: 1 (0x214a50)
NEWID FOR SYSTEM_ACTIVITY_LOG id
go
//THREAD_0x214a50:272543600.965841:2009-08-21 20:03:20 +0930
//THREADS RUNNING: 1 (0x214a50)
START TRANSACTION
go
//THREAD_0x214a50:272543600.966964:2009-08-21 20:03:20 +0930
//THREADS RUNNING: 1 (0x214a50)
INSERT INTO SYSTEM_ACTIVITY_LOG(FK_ID, new_value, users_id,
created_by_users_id, created_date, activity_type, id,
display_in_activity_log, original_value) VALUES (NULL, 'N/A', 474961,
474961, 272543596.553, 'Continuing Education Deleted', 4463891, 1,
'Shelley1')
go
//THREAD_0x214a50:272543600.968452:2009-08-21 20:03:20 +0930
//THREADS RUNNING: 1 (0x214a50)
DELETE FROM CECONTRIBUTOR_SELFSTUDY WHERE ID = 5092911
go
//THREAD_0x214a50:272543601.033233:2009-08-21 20:03:21 +0930
//THREADS RUNNING: 1 (0x214a50)
DELETE FROM SELF_STUDIES WHERE SSTUD_ID = 2281741
go
//THREAD_0x214a50:272543601.060670:2009-08-21 20:03:21 +0930
//THREADS RUNNING: 1 (0x214a50)
COMMIT
go
//THREAD_0x214a50:272543601.119748:2009-08-21 20:03:21 +0930
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
delete issue:
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//THREAD_0x214a50:272543241.750355:2009-08-21 19:57:21 +0930
//THREADS RUNNING: 1 (0x214a50)
NEWID FOR SYSTEM_ACTIVITY_LOG id
go
//THREAD_0x214a50:272543580.825637:2009-08-21 20:03:00 +0930
//THREADS RUNNING: 1 (0x214a50)
START TRANSACTION
go
//THREAD_0x214a50:272543580.826662:2009-08-21 20:03:00 +0930
//THREADS RUNNING: 1 (0x214a50)
INSERT INTO SYSTEM_ACTIVITY_LOG(FK_ID, new_value, users_id,
created_by_users_id, created_date, activity_type, id,
display_in_activity_log, original_value) VALUES (NULL, 'N/A', 474961,
474961, 272543233.654, 'Continuing Education Deleted', 4463881, 1,
'Shelley0')
go
//THREAD_0x214a50:272543580.828482:2009-08-21 20:03:00 +0930
//THREADS RUNNING: 1 (0x214a50)
DELETE FROM CECONTRIBUTOR_SELFSTUDY WHERE ID = 5092921
go
//THREAD_0x214a50:272543580.876617:2009-08-21 20:03:00 +0930
//THREADS RUNNING: 1 (0x214a50)
DELETE FROM SELF_STUDIES WHERE SSTUD_ID = 2281751
go
//THREAD_0x214a50:272543580.897282:2009-08-21 20:03:00 +0930
//THREADS RUNNING: 1 (0x214a50)
COMMIT
go
//THREAD_0x214a50:272543580.918562:2009-08-21 20:03:00 +0930
_______________________________________________
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