Issue Task Closed

#45532Improve FAL performance

Dmitry Dulepov 02/16/13, 16:54 updated 10/02/18, 12:35

Description

FAL performance in BE and FE can be improved by using certain database indexes.

One set of indexes improves performance in BE by adding a “deleted” column, which is used by List module. Without this column in the ‘pid’ index, List module will do a full scan, which is much slower.

Another set of indexes improves performance when getting files from storage.

Reviews 1