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: Wed, 26 Aug 2009 17:11:19 -0700
On Aug 26, 2009, at 4:59 PM, Shelley Eitzen wrote:
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
Are you sure these are deleting a single row?
DELETE FROM CECONTRIBUTOR_SELFSTUDY WHERE ID = 5092911
DELETE FROM SELF_STUDIES WHERE SSTUD_ID = 2281741
Any other suggestions?
1. Verify that PK and FK columns have indexes
2. Repair the database if it supports it
3. Complain to OpenBase
4. Migrate to a database that can handle the size of data you are
using. PostgreSQL and FrontBase would be good choices. Maybe MySQL
if you go that way.
Chuck
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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
--
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