#108407Missing index for language fields in table "sys_file_collection"
Description
Using sys_file_collection on a multilanguage setup leads to some performance issues.
A small addition KEY language_identifier (l10n_parent,sys_language_uid) to the table SQL configuration makes it a lot faster.
The language fields are there by default but no index like in other tables.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Related issues 1
History 3
-
Garvin Hicking changed Related to #108490 <span data-processor="relativetime" data-value="2025-12-16T07:36:45+00:00" > 12/16/25, 07:36 </span>
-
Benni Mack commented and changed status
NewClosed <span data-processor="relativetime" data-value="2026-07-29T13:23:40+00:00" > 07/29/26, 13:23 </span> -
Benni Mack changed Sprint Focus On Location Sprint <span data-processor="relativetime" data-value="2026-08-06T16:02:43+00:00" > 08/06/26, 16:02 </span>
Fixed with #96729