[TYPO3-core] FYI72: Feature 9289: Missing index for deleting outdated session data in fe_session_data

[Christian Kuhn]

* Committed to trunk rev. 7155

Thanks
Christian

Christian Kuhn wrote:
> Branches: trunk
> 
> BT: http://bugs.typo3.org/view.php?id=9289
> 
> Problem:
> On every 100th FE access (in the middle) a garbage collection for table 
> fe_session_data is executed with a query like "DELETE FROM 
> fe_session_data WHERE tstamp < too old". As this table can have lots of 
> records, the query might be pretty slow because of a missing key on 
> tstamp field.
> 
> Solution:
> Add key on tstamp field