Project

General

Profile

Actions

Bug #54927

closed

FAL - Filelist SQL Optimization

Added by Ingo Schmitt over 10 years ago. Updated over 6 years ago.

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

100%

Estimated time:
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

Actions

Also available in: Atom PDF