Task #79696
Updated by Thomas Hohn almost 8 years ago
In most cases the @tstamp@ column is a better index than the existing indexes. Looking at the selects performed on @sys_log@ in the core of TYPO3 reveals that a combination of tstamp, type, userid should tstamp giver a better performance. for certain SQL statements. At least 2 SQL statements benefit from the 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. index @timestamp@