Project

General

Profile

Actions

Bug #91208

closed

Performance issue in PageRepository for Mega Menus

Added by Stefan Froemken over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Should have
Category:
Performance
Target version:
Start date:
2020-04-27
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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


Files

WithPatch.png (49.6 KB) WithPatch.png Stefan Froemken, 2020-04-27 19:30
WithoutPatch.png (63.7 KB) WithoutPatch.png Stefan Froemken, 2020-04-27 19:30

Related issues 6 (0 open6 closed)

Related to TYPO3 Core - Bug #57953: Rendering time of HMENU is really bad, maybe bug?Closed2014-04-15

Actions
Related to TYPO3 Core - Bug #91413: InvalidArgumentException in PageRepository having too many user group idsClosed2020-05-15

Actions
Related to TYPO3 Core - Bug #91428: hidDelWhere cache is not written in v9Closed2020-05-18

Actions
Related to TYPO3 Core - Bug #91429: Initlialisation of $this->where_groupAccess missing in init method of TYPO3\CMS\Frontend\Page\PageRepositoryClosed2020-05-18

Actions
Related to TYPO3 Core - Bug #91432: PageRepository PageRepository_hidDelWhere cache should consider more attributesRejected2020-05-18

Actions
Related to TYPO3 Core - Bug #98964: Menu object caching creates too many records resulting in huge cache_hash tableClosed2022-11-01

Actions
Actions

Also available in: Atom PDF