if filemetadate-extension is installed it adds an extremely slow MM-Relation to file_mata_data-table.
Please install this extension and try to open an fe_group record in BE listmodule. As more file-meta_data exists as slower the records will open. In our case we have 54.000 filemetadata records, and for each record it executes 54.000 queries to retrieve the title of sys_file. We have to wait nearly 5 minuten to edit an fe_group record. And please have a look into sys_file_fegroups_mm. It's EMPTY! So why search for things which aren't there?
[BUGFIX] Access to sys_files is incompatible to fe_access checks
The system extension filemetadata adds access restriction fields
for selecting frontend user groups as known from tt_content or
pages. Behind the scenes of the TCEform this relation is stored
in a MM table which is incompatible to the usual access checks.
In addition a opposite relation is added to fe_groups which
queries all files to show in a selector.
This change removes the MM table and reconfigures the fe_groups
field in the same way as it is done for tt_content and pages.
Reviewed-by: Markus Klein
Reviewed-by: Stefan Froemken
Tested-by: Stefan Froemken
Reviewed-by: Frans Saris
Reviewed-by: Steffen Ritter
Tested-by: Steffen Ritter