Actions
Bug #54923
closedIncrease SQL performance for sys_file_storage
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
Start date:
2014-01-13
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
The BE Userauth is issuing the following SQL Query without any Index. Although the result is normally fetched pretty fast, it won't be stored in the Query cache, since no index is used.
SELECT * FROM sys_file_storage WHERE 1=1 AND sys_file_storage.hidden=0 AND sys_file_storage.deleted=0;
Solution 1: Add combined key to hidden and deleted
Also fields in the SQL don't match the TCA
name, tinytext. TCA Char 30
processingfolded, tinytext, TCA char 20
Solution 2: Change the Field definition
Actions