Feature #20877

Optimize database queries to session tables

Added by Oliver Hader almost 11 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2009-08-13
Due date:
% Done:

100%

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)

0011708.patch View (1.93 KB) 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_data Closed 2008-09-04

Associated revisions

Revision 6c6aad9c (diff)
Added by Oliver Hader almost 9 years ago

[FEATURE] Session tables: add key for ses_timestamp and simplify timeout-check

  • add a key for ses_timestamp (in SQL) to speedup searches
    for sessions within timeout-limit
  • simplify the overly-complex timeout-check

Change-Id: I171a63a0a7ec8cdd17c59d34411b41483d672b0f
Resolves: #20877
Reviewed-on: http://review.typo3.org/3341
Reviewed-by: Susanne Moog
Tested-by: Susanne Moog
Reviewed-by: Christian Kuhn
Tested-by: Christian Kuhn

History

#1 Updated by Mr. Hudson almost 9 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 9 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 9 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 9 years ago

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

#5 Updated by Xavier Perseguers about 8 years ago

  • Status changed from Resolved to Closed

#6 Updated by Ernesto Baschny almost 7 years ago

  • Target version deleted (4.6.0-beta1)

Also available in: Atom PDF