Issue Bug Rejected

#59826Better index for sys_language

Stefan Froemken 06/23/14, 18:55 updated 08/04/15, 19:59

Description

Hello Core-Team,

I found a better index for sys_language

|        1 | 0.00040700 | SELECT sys_language.* FROM sys_language WHERE sys_language.hidden=0 ORDER BY sys_language.title |
|        2 | 0.00024000 | SELECT sys_language.* FROM sys_language WHERE sys_language.hidden=0 ORDER BY sys_language.title |

The sum of ALL cols of sys_language in an UTF-8 environment is 348 Byte. The max. allowed size for an index on a default environment of MySQL is 1024. So why not adding all cols in ONE index? So USING INDEX is also possible.

Stefan

Reviews 1