Bug #54927

FAL - Filelist SQL Optimization

Added by Ingo Schmitt almost 6 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
Start date:
2014-01-13
Due date:
% Done:

100%

TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

When opening the FAL Filelist, for each element a SQL Statement SELECT * FROM sys_file_metadata WHERE l10n_parent=18483 AND sys_language_uid>0; is issued. The columns are not included in an index.

Solution: Add an index for the FAL Filelist

Associated revisions

Revision cc3b0298 (diff)
Added by Ingo Schmitt almost 6 years ago

[TASK] Add index to sys_file_metadata

Since sys_file_metadata records are enabled to be
translated the file list module is capable of metadata
translations, too. In order to directly link to edit
or create a new translation depending on wether this
language already has been translated for each file the
metadata translations are fetched from the database.

In order to improve that query this patch adds an index
including l10n_parent and sys_language_uid.

Resolves: #54927
Releases: 6.2
Change-Id: I6cc5c74505e96647c5ddd7e7ee77518176d2ba0b
Reviewed-on: https://review.typo3.org/26774
Reviewed-by: Steffen Ritter
Tested-by: Steffen Ritter
Reviewed-by: Benjamin Mack
Tested-by: Benjamin Mack

History

#1 Updated by Gerrit Code Review almost 6 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/26774

#2 Updated by Gerrit Code Review almost 6 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/26774

#3 Updated by Gerrit Code Review almost 6 years ago

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

#4 Updated by Gerrit Code Review almost 6 years ago

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

#5 Updated by Ingo Schmitt almost 6 years ago

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

#6 Updated by Riccardo De Contardi about 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF