Issue Task Rejected

#55169Extbase: fetch child objects in one query

Felix Oertel 01/20/14, 14:56 updated 10/17/17, 17:40

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.

Reviews 1

Subtasks 1