Project

General

Profile

Actions
Copy link

Task #45532

closed

Improve FAL performance

Added by Dmitry Dulepov almost 12 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
-
Start date:
2013-02-16
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.1
PHP Version:
Tags:
Complexity:
medium
Sprint Focus:

Description

FAL performance in BE and FE can be improved by using certain database indexes.

One set of indexes improves performance in BE by adding a "deleted" column, which is used by List module. Without this column in the 'pid' index, List module will do a full scan, which is much slower.

Another set of indexes improves performance when getting files from storage.

Files

fal_performance.diff (1.37 KB) fal_performance.diff Dmitry Dulepov, 2013-02-16 16:54
Actions
Copy link

Also available in: Atom PDF