Issue Feature Closed

#20877Optimize database queries to session tables

Oliver Hader 08/13/09, 16:37 updated 06/01/13, 14:45

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)

Reviews 1