#55167Extbase: avoid parseQuery() / buildQuery() to be called multiple times
Description
At the moment the extbase persistence runs buildQuery() and parseQuery() for every single getObjectDataByQuery() / getObjectCountByQuery(). When fetching child objects, this is called for every single object. This results in a lot of re-run code. In a simple blog_example page, this is called up to 200 times.
We will try to cache the built query as in an live environment always the same queries should be run, just with different parameters. Special care is to be taken for which parts of the query are “static” and about to be built into the cache identifier.
We will have to give the developer the chance to disable query caching though, because in some cases it might result in real big data piles. (e. g. matrix-like queries, allowing the front-end to influence the number of queried properties (search)).
Reviews 6
- main 28715[BUGFIX] FOLLOWUP Queries with NULL don't work
- main 28592[BUGFIX] Queries with NULL don't work anymore
- main 27555[TASK] Use queryCache in generic persistence
- main 28511[BUGFIX] Named parameters in Extbase comparison queries
- main 28297[TASK] Follow-up to "Add functional tests for generic persistence"
- main 28262[TASK] Add functional tests for generic persistence
Subtasks 6
- Task #55661Add functional tests for extbase persistence
- Task #57104Regression: Query building fails for LazyObjectStorage
- Task #57130Extbase Queries with NULL comparison don't work anymore
- Task #57173Use of cf_extbase_typo3dbbackend_queries results in fatal
- Task #57263Typo3DbQueryParser does not handle LowerCaseInterface correctly
- Task #57338Make Typo3DbQueryParser Singleton
Related issues 5
- Task #53514Extbase: DataMapper causes redundant queries
- Bug #57053Regression: Extbase query builder uses invalid parameter in parseComparison()
- Task #57275Add first level cache for the query cache
- Task #57280Introduce setting to be able to disable Extbase query cache for all queries.
- Task #55360Extbase: use preparedStatement in generic persistence