Serendipity Forums

Posted: **Thu Aug 24, 2006 10:07 pm**

futzing around the db and when I checked it it gave this:

Problems with indexes of table `serendipity_access`
More than one INDEX key was created for column `artifact_id`
Problems with indexes of table `serendipity_entryproperties`
UNIQUE and INDEX keys should not both be set for column `entryid`
Problems with indexes of table `serendipity_entrytags`
PRIMARY and INDEX keys should not both be set for column `entryid`
Problems with indexes of table `serendipity_groupconfig`
More than one INDEX key was created for column `id`

Is that a problem?

Posted: **Fri Aug 25, 2006 11:43 am**

Hi!

This is a problem of phpMyAdmin, sadly. It does not tell you properly, that the message is just a warning that might or MIGHT NOT apply. In some cases it's perfectly allright to have multiple indixes with same columns to improve performance for specific queries.

Best regards,
Garvin

Serendipity Forums

problems with db indexes?

problems with db indexes?

Re: problems with db indexes?