Bug #53702
Epic #55070: Workpackages
Epic #55065: WP: Overall System Performance (Backend and Frontend)
Bug #52949: Speed decrease since 4.5
FAL fetches storages twice on every BE request
Status: | Resolved | Start date: | 2013-11-16 | |
---|---|---|---|---|
Priority: | Should have | Due date: | ||
Assigned To: | - | % Done: | 0% |
|
Category: | File Abstraction Layer (FAL) | Spent time: | - | |
Target version: | - | |||
TYPO3 Version: | 6.2 | Is Regression: | No | |
PHP Version: | Sprint Focus: | |||
Complexity: |
Description
FAL fetches the storages twice on every request.
1SELECT COUNT(uid) FROM sys_file_storage WHERE 1=1;
2SELECT * FROM sys_file_storage WHERE 1=1 AND sys_file_storage.hidden=0 AND sys_file_storage.deleted=0;
StorageRepository->findAll() tries to detect if there's ever been a storage, and if not so it creates one for /fileadmin.
Maybe this can be optimized somehow to have only one DB access.
Related issues
History
#1 Updated by Alexander Opitz over 1 year ago
Hi Markus,
as this doesn't happen on fully cached frontend requests, can you write down what types of requests this happen?
#2 Updated by Markus Klein over 1 year ago
Yes looks like this only happens in the BE.
#3 Updated by Markus Klein over 1 year ago
- Subject changed from FAL fetches storages twice on every request to FAL fetches storages twice on every BE request
#4 Updated by Philipp Gampe over 1 year ago
IMHO this magic create storage stuff should be moved to the install tool as an upgrade wizard.
#5 Updated by Markus Klein over 1 year ago
- Parent task set to #52949
#6 Updated by Ingo Schmitt over 1 year ago
- Status changed from New to Resolved
Was fixed by issue #55186