Issue Bug Closed

#19287missing index for deleting outdated session data in fe_session_data

Sebastian Mendel 09/04/08, 14:45 updated 07/02/10, 11:16

Description

in class.tslib_feuserrauth.php:fetchSessionData() is a query to delete outdated data, with a WHERE condition on `tstamp` which has no index – at least for the system i am observing right now – this takes 1.3 seconds on average (executed 10k times on 24h) – way too long

is there any reason why there is no index on `tstamp`?

(issue imported from #M9289)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.