Actions
Feature #20877
closedOptimize database queries to session tables
Start date:
2009-08-13
Due date:
% Done:
100%
Estimated time:
PHP Version:
5.2
Tags:
Complexity:
Sprint Focus:
Description
Database queries to session tables will be performed each request when a frontend or backend user is logged in. To determine whether a session has expired in between always the "ses_tstamp" field is evalated.
However, there is room for improvement:- define an index in the field ses_tstamp for the tables be_sessions and fe_sessions
- rewrite the condition to check against expired session to only use precalculated values and make use of the new index (only used in the backend module to show online users)
(issue imported from #M11708)
Files
Actions