Project

General

Profile

Actions

Feature #20877

closed

Optimize database queries to session tables

Added by Oliver Hader over 15 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
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

0011708.patch (1.93 KB) 0011708.patch Administrator Admin, 2009-08-13 16:49

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #19287: missing index for deleting outdated session data in fe_session_dataClosedChristian Kuhn2008-09-04

Actions
Actions

Also available in: Atom PDF