Task #79696
Updated by Thomas Hohn almost 8 years ago
Looking at the selects performed on sys_log @sys_log@ in the core of TYPO3 reveals that a combination of@ of tstamp, type, userid@ userid should give giver a better performance performance. for at certain SQL statements. At least 2 SQL statements. One performing a full-table scan - statements benefit from the other approximately half a full-table scan. nex index. 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.