Bug #54729
closed
Improve SQL Performance on non cached pages
100%
Description
When a page is rendered, for each image a call against sys_file_processedfile is made. Analysing this in mysql slow log, the output is clear:
Count: 66 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (66), root[root]@localhost
SELECT * FROM sys_file_processedfile WHERE original=N AND task_type='S' AND configurationsha1='S' LIMIT N
Solution should be to add the needed fields to an index.
Updated by Gerrit Code Review over 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/26628
Updated by Gerrit Code Review over 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/26628
Updated by Gerrit Code Review over 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/26628
Updated by Ingo Schmitt over 10 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset e7195cf7cb700e11f4023af9c0987b395d31901a.
Updated by Riccardo De Contardi over 6 years ago
- Status changed from Resolved to Closed