Task #79696
closed
Better index on sys_log
100%
Description
Looking at the selects performed on sys_log in the core
of TYPO3 reveals that a combination of@ tstamp, type, userid@
should give a better performance for at least 2 SQL
statements. One performing a full-table scan - the other
approximately half a full-table scan.
On installations where a few users have created a lot of entries
in sys_log the existing indexes event and user_auth will return
too many rows compared to the new combined index.
Updated by Gerrit Code Review almost 8 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595
Updated by Gerrit Code Review almost 8 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595
Updated by Thomas Hohn almost 8 years ago
- Subject changed from Timestamp better index on sys_log to Better index on sys_log
- Description updated (diff)
Updated by Gerrit Code Review almost 8 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595
Updated by Gerrit Code Review almost 8 years ago
Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595
Updated by Gerrit Code Review almost 8 years ago
Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595
Updated by Christian Kuhn almost 8 years ago
- Target version changed from 8.6 to 8 LTS
- Sprint Focus set to Stabilization Sprint
Updated by Thomas Hohn almost 8 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 54709754c7af46d4cc27fd900e4e1cd0f05081f6.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Resolved to Closed