Feature #20877

Optimize database queries to session tables

Added by Oliver Hader almost 12 years ago. Updated about 8 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

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

Actions
#1

Updated by Mr. Hudson almost 10 years ago

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

#2

Updated by Mr. Hudson almost 10 years ago

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

#3

Updated by Mr. Hudson almost 10 years ago

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

#4

Updated by Anonymous almost 10 years ago

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

Updated by Xavier Perseguers over 9 years ago

  • Status changed from Resolved to Closed
#6

Updated by Ernesto Baschny about 8 years ago

  • Target version deleted (4.6.0-beta1)

Also available in: Atom PDF