Task #79696

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