| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Naz Gassiep | Date: | May 24 2007 3:33pm |
| Subject: | Integrity on large sites | ||
| View as plain text | |||
I'm working in a project at the moment that is using MySQL, and people keep making assertions like this one: "*Really* big sites don't ever have referential integrity. Or if the few spots they do (like with financial transactions) it's implemented on the application level (via, say, optimistic locking), never the database level." A large DB working with no RI would give me nightmares. Is it really true that large sites turn RI off to improve performance? Am I just being naive in thinking that everyone runs their DBs with RI in production?
| Thread | ||
|---|---|---|
| • Integrity on large sites | Naz Gassiep | 24 May |
| • Re: Integrity on large sites | Peter Brawley | 24 May |
| • Re: Integrity on large sites | Martijn Tonies | 24 May |
| • Re: Integrity on large sites | Philip Mather | 24 May |
| • Re: Integrity on large sites | Evaldas Imbrasas | 24 May |
| • Re: Integrity on large sites | Naz Gassiep | 25 May |
| • Re: Integrity on large sites | B. Keith Murphy | 25 May |
| • Re: Integrity on large sites | Evaldas Imbrasas | 25 May |
| • Re: Integrity on large sites | Naz Gassiep | 25 May |
| • Re: Integrity on large sites | B. Keith Murphy | 25 May |
| • Re: Integrity on large sites | Barry Newton | 25 May |
| • Re: Integrity on large sites | Naz Gassiep | 25 May |
| • Re: Integrity on large sites | Naz Gassiep | 25 May |
| • Re: Integrity on large sites | Jeremy Cole | 26 May |
| • Re: Integrity on large sites | Martijn Tonies | 25 May |
| • RE: Integrity on large sites | Rhys Campbell | 25 May |
