Project

General

Profile

Actions

Feature #20877

closed

Optimize database queries to session tables

Added by Oliver Hader over 14 years ago. Updated almost 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 #1

Updated by Mr. Hudson over 12 years ago

Patch set 1 of change I171a63a0a7ec8cdd17c59d34411b41483d672b0f has been pushed to the review server.
It is available at http://review.typo3.org/3341

Actions #2

Updated by Mr. Hudson over 12 years ago

Patch set 2 of change I171a63a0a7ec8cdd17c59d34411b41483d672b0f has been pushed to the review server.
It is available at http://review.typo3.org/3341

Actions #3

Updated by Mr. Hudson over 12 years ago

Patch set 3 of change I171a63a0a7ec8cdd17c59d34411b41483d672b0f has been pushed to the review server.
It is available at http://review.typo3.org/3341

Actions #4

Updated by Anonymous over 12 years ago

  • Status changed from Accepted to Resolved
  • % Done changed from 0 to 100
Actions #5

Updated by Xavier Perseguers about 12 years ago

  • Status changed from Resolved to Closed
Actions #6

Updated by Ernesto Baschny almost 11 years ago

  • Target version deleted (4.6.0-beta1)
Actions

Also available in: Atom PDF