Re: CMS, foreign keys, and the legacy of MySQL

On 3/17/11 11:52 AM, jj ff wrote:
> Here's a comment I found while googling around on these issues:  "The
> problem isn't that InnoDB itself is slow, it's that enforcing foreign
> key relations is slow. I'm a big fan of referential integrity, but in a
> CMS it's place is in the application layer, not the data layer."  Why
> would anyone say that?  What's the point of using a DB if you're not
> doing to put FKs in it?

Well, they're right ... for InnoDB.  If you're only experience with a
relational database is MySQL, then you're liable to think that FKs are a
disaster.

--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com