#45532Improve FAL performance
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.