Task #79696

Updated by Thomas Hohn over 7 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@