On Wed, Apr 12, 2006 at 09:22:52AM +0200, PFC wrote:
>
> >> I think this is an old question, but I want to know if it really is
> >>well worth to not create some foreign keys an deal with the referential
> >>integrity at application-level?????
>
> Trust me : do it in the application and you'll enter a world of
> hurt. I'm doing it with some mysql apps, and it's a nightmare ; doing
> cascaded delete's by hand, etc, you always forget something, you have to
> modify a million places in your code everytime you add a new table, your
> ORM bloats, you get to write cleanup cron scripts which take forever to
> run, your website crashes etc.
Well, yeah, thats typical for MySQL sites, but what's that have to do
with RI?
Sorry, couldn't resist. :P