Issue Task Closed

#79696Better index on sys_log

Thomas Hohn 02/08/17, 20:23 updated 10/17/17, 23:32

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.

Reviews 1