Bug #54927
closedFAL - Filelist SQL Optimization
100%
Description
When opening the FAL Filelist, for each element a SQL Statement SELECT * FROM sys_file_metadata WHERE l10n_parent=18483 AND sys_language_uid>0; is issued. The columns are not included in an index.
Solution: Add an index for the FAL Filelist
Updated by Gerrit Code Review about 10 years ago
- Status changed from New to Under Review
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/26774
Updated by Gerrit Code Review about 10 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/26774
Updated by Gerrit Code Review about 10 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/26774
Updated by Gerrit Code Review about 10 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/26774
Updated by Ingo Schmitt about 10 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset cc3b0298583fbc0d1071d6dfdb9666361b0da9c6.
Updated by Riccardo De Contardi over 6 years ago
- Status changed from Resolved to Closed