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 almost 7 years ago. Updated over 3 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
 #1

Updated by Christian Eßl over 4 years ago

  • Category set to Performance
Actions
Copy link
 #2

Updated by Benni Mack almost 4 years ago

  • Status changed from New to Needs Feedback

Hey Florian,

isn't this fixed with 79604 ? I think the KEY

    KEY combined_1 (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)

also helps a lot. Can you share your findings?

Actions
Copy link
 #3

Updated by Sybille Peters over 3 years ago

  • Related to Task #79604: Missing index on sys_file_reference added
Actions
Copy link
 #4

Updated by Sybille Peters over 3 years ago

  • Tags set to performance
Actions
Copy link
 #5

Updated by Tymoteusz Motylewski over 3 years ago

  • Status changed from Needs Feedback to Closed

Seems the problem is already solved, if not please let us know.

Actions
Copy link

Also available in: Atom PDF