Issue Bug Closed

#54927FAL - Filelist SQL Optimization

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

Description

When opening the FAL Filelist, for each element a SQL Statement SELECT * FROM sys_file_metadata WHERE l10n_parent=18483 AND sys_language_uid>0; is issued. The columns are not included in an index.

Solution: Add an index for the FAL Filelist

Reviews 1