Issue Bug Closed

#54923Increase SQL performance for sys_file_storage

Ingo Schmitt 01/13/14, 09:08 updated 10/23/17, 21:41

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

Reviews 2