Project

General

Profile

Actions
Copy link

Bug #19287

closed

missing index for deleting outdated session data in fe_session_data

Added by Sebastian Mendel over 15 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Christian Kuhn
Category:
-
Target version:
-
Start date:
2008-09-04
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

in class.tslib_feuserrauth.php:fetchSessionData() is a query to delete outdated data, with a WHERE condition on `tstamp` which has no index - at least for the system i am observing right now - this takes 1.3 seconds on average (executed 10k times on 24h) - way too long

is there any reason why there is no index on `tstamp`?

(issue imported from #M9289)

Files

9289_01.diff (433 Bytes) 9289_01.diff Administrator Admin, 2010-03-23 00:21

Related issues 2 (0 open — 2 closed)

Related to TYPO3 Core - Feature #20877: Optimize database queries to session tablesClosedOliver Hader2009-08-13

Actions
Has duplicate TYPO3 Core - Bug #21716: TYPO3 randomly needs up to 1 minute to answer requests (includes bugfix)Closed2009-11-27

Actions
Actions
Copy link

Also available in: Atom PDF