Actions
Bug #59826
closedBetter index for sys_language
Status:
Rejected
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2014-06-23
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.4
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:
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
Actions