Project

General

Profile

Actions
Copy link

Feature #25386

closed

Index over sys_log event_pid for "order by page" in syslog view

Added by René over 13 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Logging
Target version:
-
Start date:
2011-03-24
Due date:
% Done:

0%

Estimated time:
PHP Version:
5.3
Tags:
Complexity:
Sprint Focus:

Description

Hi.

we've noticed some real time expensive querys on the syslog table under some circumstances.

If we show many entrys from sysprotocol and activate "order by page" the folowing index would speed up the query extremly.

the syslog index "event" has the userid appended and will not match.

ALTER TABLE `sys_log` ADD INDEX `sortedPages` (`event_pid`);

(issue imported from #M18027)

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Task #29279: Add some index to sys_logClosed2011-08-26

Actions
Actions
Copy link

Also available in: Atom PDF