New Posts New Posts RSS Feed: WillCascadeOnDelete and deletion of loaded related entities
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

WillCascadeOnDelete and deletion of loaded related entities
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
kdev View Drop Down
Groupie
Groupie
Avatar

Joined: 03-Jan-2013
Posts: 83 		Post Options Post Options   Quote kdev Quote  Post ReplyReply Direct Link To This Post Topic: WillCascadeOnDelete and deletion of loaded related entities
    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
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down