On Jun 08, Corbelli Giuseppe <[EMAIL PROTECTED]> wrote: > I am by no means a Mysql expert,
Me neither, I'm just a poor little user. :-) > but AFAIK the InnoDB backend supports referential integrity. True, I'm still using MyISAM backend. > Yes. Situation is: foreign keys REQUIRE indexes under MySQL > 5/InnoDB. This leads to unacceptable performance. So we REMOVE all > foreign keys and use plain columns, instead. Is this correct? The logic is correct, but I'm not sure that we'll _have_ to remove these few foreign keys: it's possible that their presence doesn't affect performance too much. These indexes on foreign keys are created even with MyISAM backend - and they seems to be "filled with the data", but the performances are acceptable. I'll do some tests with InnoDB, thanks for the hint! -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
