#79696Better index on sys_log
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.