Hi On Monday 30 July 2007 22:06:33 Francisca Hernández wrote: > Hi, > > i used to work with postgresql but i did a project with mysql to > improve performace of site like ezpublish recommend. > i run CHECK TABLE and i see this warnings: > > Problems with indexes of table `ezcontentobject_attribute` > - PRIMARY and INDEX keys should not both be set for column `id` > - More than one INDEX key was created for column `contentobject_id` > (...) > is this a problem for ezp performance? can this affect the > performance of site? > anyone can help me? Who do you get these warnings, are you using the Mysql command client or phpmyadmin ? What version of Mysql are you running? Having two identical indexes on a table would not make sence, I agree. However, the indexes are not identical. some of the indexes are multi-column indexes and will serve different kinds of queries. However, having more keys gives a small performance penalty on inserts.
Best regards, Vidar L -- [EMAIL PROTECTED] | eZ systems | ez.no -- Sdk-public mailing list [email protected] http://lists.ez.no/mailman/listinfo/sdk-public
