Wednesday, August 29, 2012

deleteAll cascade efficiency

Hi there,

I have a question towards the one who know who Cake internally works. I'm using MySql with InnoDB engine and therefore I have full foreignkey support. I have also set all the on update and on delete actions in database, so I can say I can totally rely on the DB now and can turn off the cascade every where that I have a delete on my models. But is it really necessary to go through them all and set the cascade to false for efficiency? or it will not change any thing. the difference is if the Cake removes the parent model before children the it does not rely on DB and is inefficient.
this is unfortunately not documented in book: http://book.cakephp.org/2.0/en/models/deleting-data.html

thanks for any tip in advance.

Regards,
MN

--
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
 
 

No comments: