Hugo Kornelis (3/21/2013)
Toreador (3/21/2013)
Using cascade delete. If the business rule says that is the appropriate behaviour, then why avoid using inbuilt functionality that achieves exactly what you need?One possible reason is that you can't control the order of locks being taken with cascading deletes and cascading updates. That makes it harder to avoid deadlock scenarios if you are in a high concurrency scenario.
Other than that, I see no reason not to use this feature *IF* that is what the business wants. However, in my experience the number of scenarios where the business actually wants to delete dependent rows automatically is very small.
+1 .. I have been, in the past, specifically asked to avoid cascade delete (after I suggested them, that's a different case 😀 ).
if the business say so .. I am not sure ..
I really can't think of a scenario where business would allow that .. although, I would definitely code it for Police database , if they got a record of mine 😀
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: