Core Data delete performance
Core Data delete performance
- Subject: Core Data delete performance
- From: Diederik Hoogenboom <email@hidden>
- Date: Sat, 16 Dec 2006 19:19:25 +0100
Hi,
I have a tree-like data structure as my core data model. When I
delete the top node with some 30,000 underlying objects (max 7 levels
deep) then the cascade delete of the objects takes about 30-40 seconds.
What I see when I turn sqldebug on is that for each object a
'CoreData: annotation: to-many relationship fault' is executed for
the sqlite database.
I have tried to do batch faulting for the whole tree structure (which
is easy as each object has a link back to the top node) before the
deleteObject: but this does not seems to help (I guess batch faulting
will not solve the one-to-many releationship faults).
Turning off cascade delete, and deleting the individual obejcts, does
not help either as I see the same pattern emerge in the sqldebug trace.
Any clues?
Thanks,
Diederik
--
Diederik Hoogenboom
Obvious Matter
http://www.obviousmatter.com
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden