Issue Bug Closed

#54729Improve SQL Performance on non cached pages

Ingo Schmitt 01/03/14, 16:57 updated 10/23/17, 21:46

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.

Reviews 1