#81906Better performance for translated FileReference entities - new index in sys_file_reference
Description
When you are using language overlays and you have an untranslated entity with multiple related FileReference objects the lookup of the overlay FileReference objects is very slow. The following index significantly speeds this up:
CREATE TABLE sys_file_reference (
KEY localization_parent (pid,sys_language_uid,l10n_parent)
);
I think it would be safe to include this additional index by default.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.