Issue Bug Closed

#91208Performance issue in PageRepository for Mega Menus

Stefan Froemken 04/27/20, 15:26 updated 05/12/20, 13:08

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