| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | PFC <lists(at)peufeu(dot)com> |
| Cc: | Michael Glaesemann <grzm(at)myrealbox(dot)com>, Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: FOREIGN KEYS vs PERFORMANCE |
| Date: | 2006-04-12 15:36:20 |
| Message-ID: | 20060412153619.GG49405@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-04-12 15:39:51 | Re: FOREIGN KEYS vs PERFORMANCE |
| Previous Message | Scott Marlowe | 2006-04-12 15:13:45 | Re: FOREIGN KEYS vs PERFORMANCE |