Project

General

Profile

Actions
Copy link

Bug #54923

closed

Increase SQL performance for sys_file_storage

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:
6.2.0
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

The BE Userauth is issuing the following SQL Query without any Index. Although the result is normally fetched pretty fast, it won't be stored in the Query cache, since no index is used.

SELECT * FROM sys_file_storage WHERE 1=1 AND sys_file_storage.hidden=0 AND sys_file_storage.deleted=0;

Solution 1: Add combined key to hidden and deleted

Also fields in the SQL don't match the TCA

name, tinytext. TCA Char 30
processingfolded, tinytext, TCA char 20

Solution 2: Change the Field definition

Actions
Copy link

Also available in: Atom PDF