FAL - Filelist SQL Optimization
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
[TASK] Add index to sys_file_metadata
Since sys_file_metadata records are enabled to be
translated the file list module is capable of metadata
translations, too. In order to directly link to edit
or create a new translation depending on wether this
language already has been translated for each file the
metadata translations are fetched from the database.
In order to improve that query this patch adds an index
including l10n_parent and sys_language_uid.
Reviewed-by: Steffen Ritter
Tested-by: Steffen Ritter
Reviewed-by: Benjamin Mack
Tested-by: Benjamin Mack