#55182Speedup selection of storage
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
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.