Actions
Task #79696
closed
Better index on sys_log
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2017-02-08
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Sprint Focus:
Stabilization Sprint
Description
Looking at the selects performed on sys_log in the core
of TYPO3 reveals that a combination of@ tstamp, type, userid@
should give a better performance for at least 2 SQL
statements. One performing a full-table scan - the other
approximately half a full-table scan.
On installations where a few users have created a lot of entries
in sys_log the existing indexes event and user_auth will return
too many rows compared to the new combined index.
Updated by 
Updated by 
Updated by 
Updated by
Actions