Project

General

Profile

Actions
Copy link

Feature #81906

closed

Better performance for translated FileReference entities - new index in sys_file_reference

Added by Florian Schöppe over 7 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Performance
Target version:
-
Start date:
2017-07-18
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
performance
Complexity:
Sprint Focus:

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.

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Task #79604: Missing index on sys_file_referenceClosedThomas Hohn2017-02-02

Actions
Actions
Copy link

Also available in: Atom PDF