Bug #55182
Epic #55070: Workpackages
Epic #55065: WP: Overall System Performance (Backend and Frontend)
Task #55179: Optimize SQL Performance
Speedup selection of storage
| Status: | Closed | Start date: | 2014-01-20 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Ingo Schmitt | % Done: | 100% |
|
| Category: | Performance | Spent time: | 0.10 hour | |
| Target version: | 6.2.0 | Estimated time: | 2.00 hours | |
| TYPO3 Version: | 6.2 | Is Regression: | No | |
| PHP Version: | Sprint Focus: | |||
| Complexity: |
Description
the file storgae is selected by
SELECT * FROM sys_file_storage WHERE driver = 'S' AND sys_file_storage.deleted=N AND sys_file_storage.hidden=N AND sys_file_storage.deleted=N
Since there is no index on driver the query is executed without the query cache.
Solution add index in driver since there is already an index on hidden and deleted
History
#1 Updated by Ingo Schmitt over 1 year ago
- Estimated time changed from 0.50 to 2.00
#2 Updated by Ingo Schmitt over 1 year ago
SQL is no more present with current master. So Close
#3 Updated by Ingo Schmitt over 1 year ago
- Status changed from New to Closed
- % Done changed from 0 to 100