Task #106248
open
[TASK] avoid loading metadata for files if not necessary
0%
Description
The FAL has very poor performance, especially when dealing with many many files in one folder. TYPO3 will use a paginated view but will apply the pagination strategy only in the runtime after the driver has loaded all assets in one folder. But by avoiding accessing the metadata of a file the response time can still be reduced by a lot.
The default file-list rendering will sort by "file" which is the sys_file uid but will be obtained via the metadata aspect. This is not necessary as the file object should be able to return the uid without using the metadata aspect.
By simply adding one case to the getSortingValueForFile method i could reduce the response-time for a massive folder from 10 seconds to 5 seconds, which is substantial.
Please consider merging this low-hanging-fruit commit into V14/13/12, i don't want to work with custom patches :-/
This issue was automatically created from https://github.com/TYPO3/typo3/pull/557
Updated by Gerrit Code Review 19 days ago
- Status changed from New to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/88355
Updated by Gerrit Code Review 18 days ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/88355
Updated by Garvin Hicking 18 days ago
- Category set to File Abstraction Layer (FAL)
Updated by Gerrit Code Review 18 days ago
Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/88355