Issue Bug Closed

#55182Speedup selection of storage

Ingo Schmitt 01/20/14, 18:54 updated 03/11/14, 18:00

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.