#91208Performance issue in PageRepository for Mega Menus
Description
Hello Core-Team,
one of our customer has over 200 Pages in a Mega Menu. Loading this menu costs 16 seconds.
I have installed Blackfire to find the problem. Generating the where clauses for PageRepository costs 9 seconds in total, because of calling QuoteIdentifier 201.000 times.
I will create a patch, which will reduce this amount of calls below 30.000.
Stefan
Reviews 5
- 9.5 64517[BUGFIX] Use checksum of frontend groups in cache identifier
- main 64512[BUGFIX] Use checksum of frontend groups in cache identifier
- 9.5 64513[BUGFIX] Actually write cache for generated access field condition
- 9.5 64355[BUGFIX] Cache various where clauses of PageRepository
- main 64321[BUGFIX] Cache various where clauses of PageRepository
Related issues 6
- Bug #57953Rendering time of HMENU is really bad, maybe bug?
- Bug #91413InvalidArgumentException in PageRepository having too many user group ids
- Bug #91428hidDelWhere cache is not written in v9
- Bug #91429Initlialisation of $this->where_groupAccess missing in init method of TYPO3\CMS\Frontend\Page\PageRepository
- Bug #91432PageRepository PageRepository_hidDelWhere cache should consider more attributes
- Bug #98964Menu object caching creates too many records resulting in huge cache_hash table