#54729Improve SQL Performance on non cached pages
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.