Feature #20877
closed
Optimize database queries to session tables
100%
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
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change I171a63a0a7ec8cdd17c59d34411b41483d672b0f has been pushed to the review server.
It is available at http://review.typo3.org/3341
Updated by Mr. Hudson over 13 years ago
Patch set 2 of change I171a63a0a7ec8cdd17c59d34411b41483d672b0f has been pushed to the review server.
It is available at http://review.typo3.org/3341
Updated by Mr. Hudson over 13 years ago
Patch set 3 of change I171a63a0a7ec8cdd17c59d34411b41483d672b0f has been pushed to the review server.
It is available at http://review.typo3.org/3341
Updated by Anonymous over 13 years ago
- Status changed from Accepted to Resolved
- % Done changed from 0 to 100
Applied in changeset 6c6aad9cd2cb3d79fa2b8b2a539ef7fd324eb337.
Updated by Xavier Perseguers over 12 years ago
- Status changed from Resolved to Closed
Updated by Ernesto Baschny over 11 years ago
- Target version deleted (
4.6.0-beta1)