Menu addon runs double SQL query over 500 times for a single page request [1.7.6.4]

[nik]

My online shop is using a couple of menu addons, called JMSMegaMenu and JMSVerticalMenu. These came with the theme I have been using since day one, also from JMS.

I ran a profiler for diggint into some performance issue and I discovered following:
For every page request, the 2 addons run an identical sql query 456 and 231 times accordingly (once for every single menu item and subitem of the shop), inorder to fetch the names of the menu items.

 

I'm wondering if this is a good practise for Menu Addons and such an amount of double queries is normal, or if I am using an extremely badly designed addon.

I assume that this behaviour is stressing our the respective SQL tables, which highly affects the performance, and especially the TTFB, which I am having issues with.

Thanks in advance,

Nikos 

Edited September 6, 2021 by nik (see edit history)

[nik]

upping the topic

[nik]

anyone?

[Prestachamps]

Hello,

It seems that the first query is for the Mega menu, and the second one is for the vertical menu module. They are separate modules, and because of this doubles the query. 

But running the same query 456 and 231 times to get only the name of the menu items means that the modules are designed badly.

What you can try is to contact the module/theme developers and ask them to optimize the module/theme for you, or try a better-optimized module. 

Have a nice day, Leo.