http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : WillCascadeOnDelete and deletion of loaded related entities Thu, 14 May 2026 10:47:14 -700 Tue, 28 May 2013 11:16:31 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4165 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=4165&PID=16391#16391 Author: sbelini
Subject: 4165
Posted: 28-May-2013 at 11:16am

Kdev,

That is by design.

You mentioned:
I think that the "normal" behaviour should be to always have a single delete command when deleting an entity.
If the related entities were loaded in the manager, they should be detached from the manager and not explicitly deleted, because this cause multiple useless delete commands to be executed (with 1000+ related entities the performance quickly degrades).

If the cascading delete was set on the model, but not on the DB; the save call with the single delete would fail.
For this reason, the child entities are marked for deletion as well.

You will find more information about cascading deletes at http://drc.ideablade.com/xwiki/bin/view/Documentation/save-cascaded-deletes]]> Tue, 28 May 2013 11:16:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4165&PID=16391#16391 http://www.ideablade.com/forum/forum_posts.asp?TID=4165&PID=16388#16388 Author: kdev
Subject: 4165
Posted: 28-May-2013 at 9:42am

I have an issue when deleting an entity that have related entities (of a relationship configured to be cascade deleted) loaded.

DevForce deletes each related entity before deleting the root, if those entities were not loaded, the delation of the root entity generates a single delete command on the database.

I think that the "normal" behaviour should be to always have a single delete command when deleting an entity.
If the related entities were loaded in the manager, they should be detached from the manager and not explicitly deleted, because this cause multiple useless delete commands to be executed (with 1000+ related entities the performance quickly degrades).

Is this "by design" ?

Edited by kdev - 28-May-2013 at 9:43am]]> Tue, 28 May 2013 09:42:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4165&PID=16388#16388