Hello,
I opened the hMailServer database with PHPMyAdmin and I see that the tables structure is strange for the indexes. In effet, each primary key of each table is also present like an index. Why creating two indexes on the same column? For me just one index (the primary key) is suffisant for optimal performances, no ?
An other thing, the table hm_messages has a primary key on messageid and also an unique key on messageid. Why? It's the same thing. Probably same behavior in other tables.
I use hMailServer 4.3 build 248 with my own 4.1 MySQL server. This indexes problem structure was also present with hMailServer 4.2. I have well upgraded the data base structure during the installation of hMailServer 4.3.
Problem with MySQL indexes ?
-
- Normal user
- Posts: 57
- Joined: 2005-09-12 11:57
- Location: Marseille - France
-
- Normal user
- Posts: 57
- Joined: 2005-09-12 11:57
- Location: Marseille - France