Details
-
Story
-
Resolution: Unresolved
-
High
-
2.2.3, 2.3.2, 2.4.2
-
None
Description
After EZP-29659 adding in-memory cache for sections, content types and roles there are still several places in need of optimizations.
After that was solved, page builder (on ee demo) had the following remaining backend calls when cache is warm:
- 13 SQL calls
- 569 Cache calls (100% hit ratio)
Out of those 569 cache calls a big chunk of them are repeated and can be avoided by adding in-memory cache for:
- netgen-tags- (252 of the cache calls)
Solved in https://github.com/netgen/TagsBundle/releases/tag/3.4.0
Remaining are:
- ez-content-info- (124 of the cache calls)
- ez-location- (42 of the cache calls)
- ez-content- (~180 calls)
- ez-urlAlias-location-list- (27 of calls, 25 of them specifically for location 2)
Attachments
Issue Links
- clones
-
EZP-30284 As a v2 User I want optimized cache adapters for better performance
- QA
- is cloned by
-
EZP-30335 As a Developer I want in-memory cache to clear cache using LFU approach
- Documentation Done
- relates to
-
EZP-29470 As a developer I want trace for uncached Persistence calls
- QA
-
EZP-29659 As a v2 Developer I want support for InMemory SPI cache
- QA
-
EZP-30006 As a Developer I possibility to load several languages at once
- QA
-
EZP-29821 As a Developer I want less SPI calls to be done by Admin UI
- Closed