Project

General

Profile

Actions
Copy link

Bug #54729

closed

Improve SQL Performance on non cached pages

Added by Ingo Schmitt over 10 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Ingo Schmitt
Category:
Performance
Target version:
6.2.0
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
Copy link

Also available in: Atom PDF