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