Bug #54729
Improve SQL Performance on non cached pages
| Status: | Resolved | Start date: | 2014-01-03 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Ingo Schmitt | % Done: | 100% |
|
| Category: | Performance | Spent time: | - | |
| Target version: | 6.2.0 | |||
| TYPO3 Version: | 6.2 | Is Regression: | No | |
| PHP Version: | Sprint Focus: | |||
| Complexity: |
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.
Associated revisions
[BUGFIX] Add SQL Index to Processed Files DB table
Added index to original,task_type,configurationsha1
this improves performance for non-cached pages and
backend calls
Resolves: #54729
Releases: 6.2
Change-Id: I2ecfe62c64b89078da5c04ee708ea3c343d4fc9a
Reviewed-on: https://review.typo3.org/26628
Reviewed-by: Oliver Klee
Reviewed-by: Steffen Ritter
Tested-by: Steffen Ritter
Reviewed-by: Benjamin Mack
Tested-by: Benjamin Mack
History
#1 Updated by Gerrit Code Review over 1 year 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
#2 Updated by Gerrit Code Review over 1 year 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
#3 Updated by Gerrit Code Review over 1 year 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
#4 Updated by Ingo Schmitt over 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset e7195cf7cb700e11f4023af9c0987b395d31901a.