How big is your database? If it's a few megs, then who cares? If it's massive, and you have lots of hits, then it's worth copying the database somewhere, and performing some tests to see what performance you get using both methods.
Cascades can be nice, but dangerous. Often, you delete more than you think you should, which can cause some surprises. The opposite of that is that the app has to know more about the database, and take extra steps to delete down a tree of related tables, when it probably should NOT have to know those details. Since they are arguing performance, copy your database, and test it both ways. Then you'll know... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
