#54923Increase SQL performance for sys_file_storage
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