Task #55169
closedEpic #55070: Workpackages
Epic #55065: WP: Overall System Performance (Backend and Frontend)
Epic #55656: Optimize overall Extbase performance
Story #55168: Optimize Extbase generic persistence
Extbase: fetch child objects in one query
100%
Description
To get the child-objects of a collection, extbase runs one query per object. If you got an objectStorage with 10 posts each with an author, extbase will use ten queries to get them. This generates a lot of database hits on applications making heavy use of child-objects (like FAL).
We have to try to reduce the queries to one per type. It should (in theory) not be too hard, to fetch ten authors in one "uid IN (1,2,3)"-query, cache them 1st level and map them to the corresponding parent object on request.
At the moment it's only possible to set @lazy-annotation globally in the domain model, so we should give the user a way to disable pre-fetching on a per-query-base.