Project

General

Profile

Actions

Task #79604

closed

Missing index on sys_file_reference

Added by Thomas Hohn almost 8 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2017-02-02
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
performance
Complexity:
Sprint Focus:
Stabilization Sprint

Description

The table sys_file_reference has a missing index.
Like the table tt_content - there should be and index on the columns t3ver_oid,t3ver_wsid

The following select statement - that is generated during a copy of a sub-tree in the backend
could benefit greatly from that. In the test the statement was executed 136 times with a
using 1.7 seconds - as a comparison the same statement on the tt_content table took 189 ms.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Feature #81906: Better performance for translated FileReference entities - new index in sys_file_referenceClosed2017-07-18

Actions
Actions #1

Updated by Gerrit Code Review almost 8 years ago

  • Status changed from New to Under Review

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51512

Actions #2

Updated by Gerrit Code Review almost 8 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51512

Actions #3

Updated by Benni Mack almost 8 years ago

  • Target version changed from 8.6 to 8 LTS
Actions #4

Updated by Thomas Hohn almost 8 years ago

  • Sprint Focus set to Stabilization Sprint
Actions #5

Updated by Thomas Hohn almost 8 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Riccardo De Contardi about 7 years ago

  • Status changed from Resolved to Closed
Actions #7

Updated by Sybille Peters about 4 years ago

  • Related to Feature #81906: Better performance for translated FileReference entities - new index in sys_file_reference added
Actions #8

Updated by Sybille Peters about 4 years ago

  • Tags set to performance
Actions

Also available in: Atom PDF