Right. Good point. So I rephrase the question... if your db can handle it and you have the option to choose to have cake handle the relation deletes or use foreign key restraints which is best? Is there a reason to choose 1 over the other?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of cricket Sent: Tuesday, March 15, 2011 11:54 PM To: [email protected] Subject: Re: Cascade Cake vs DB On Tue, Mar 15, 2011 at 8:34 PM, Krissy Masters <[email protected]> wrote: > What are your general thoughts on using Cascade on delete in Cake vs setting > up the db to handle deleting related data? > > Is better to do which? Any reason for choosing one over another? Not all DBs support it. MyISAM tables, for instance, do not enforce referential constraints. So, for a lot of people, having Cake take care of it is the best solution. When I use Postgres, though, I let the DB handle it. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
