Actions
Feature #25386
closed
Index over sys_log event_pid for "order by page" in syslog view
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)
Updated by Felix Kopp over 11 years ago
- Target version deleted (
0)
sys_log brings a KEY to parent field (PID) in 6.2
Updated by Steffen Müller over 11 years ago
I'd put this issue on hold, until we have decided about the future of sys_log and sys_history.
Updated by Mathias Schreiber almost 10 years ago
- Category changed from Database API (Doctrine DBAL) to Logging
- Target version set to 7.4 (Backend)
Updated by Susanne Moog over 9 years ago
- Target version changed from 7.4 (Backend) to 7.5
Updated by
Updated by Riccardo De Contardi over 7 years ago
- Status changed from New to Closed
Seems already solved - if you experience the issue again then please reopen it or open a new issue with this one as reference. Thank you.
Actions