Re: FOREIGN KEYS vs PERFORMANCE

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