Issue Task Closed

#106248[TASK] avoid loading metadata for files if not necessary

TYPO3 GmbH TYPO3com 02/25/25, 12:10 updated 12/02/25, 14:22

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

Reviews 3

History 39

  1. Gerrit Code Review pushed patch set 1 for main to change 88355 status New Under Review 02/25/25, 12:10

  2. Gerrit Code Review pushed patch set 2 for main to change 88355 02/25/25, 18:24

  3. Garvin Hicking changed category 02/25/25, 20:21

  4. Gerrit Code Review pushed patch set 3 for main to change 88355 02/25/25, 21:58

  5. Gerrit Code Review pushed patch set 4 for main to change 88355 03/25/25, 14:58

  6. Gerrit Code Review pushed patch set 1 for 13.4 to change 88744 03/25/25, 15:07

  7. Gerrit Code Review pushed patch set 1 for 12.4 to change 88745 03/25/25, 15:07

  8. Anonymous commented and changed status Under Review Resolved done 0 % 100 % 03/25/25, 15:10

    Applied in changeset commit:03bad68abe510af397e5755913cd91f51351724e.

  9. Benni Mack changed status Resolved Closed 12/02/25, 14:22