Actions
Bug #54729
closedImprove SQL Performance on non cached pages
Start date:
2014-01-03
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
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.
Actions