MaximenuCK duplicate queries with VM3

Hi,

i'm using MaxmenuCK 8.0.20 with Joomla 3.4.5 & Virtuemart 3.0.12 and the Virtuemart patch.

The Problem what i've got is that the Maximenu is creating 66 duplicate queries on the Database from the virtuemart_categories table.
This is slowing down the site by 0.5 seconds and is an serious problem.
With the standart virtuemart category module i've got 100 queries on the database and 20 duplicates and with maximenu there are 227 queries and 88 duplicates in total.

Is there a way to fix it?

Thx

Otto

Hi
Actually there is no existing SQL method that returns all the needed datas to create the menu
I have to ask the database with a custom query to retrieve all the informations, that is why you have more querys with the menu

You can limit the depth of categories to show, the more you show, the more queries you will get.

If you find a VM method that could be used instead of using a SQL query, let me know
CEd

Hi,


i think the main problem is all these duplicate queries, wich don't appear with the original vm-category modul...for them there is also no solution?

I'm using a category depth of "2"

where do you see these duplicate queries ? do you have some examples ?

I just saved the full site with the debug-log; if you give me an e-mail adress i can send it.
Here ist an example of one duplicate, this happens 34 times:


Doppelte Abfragen: #92
SELECT *, k3rbu_virtuemart_categories.virtuemart_category_id as id, k3rbu_virtuemart_category_categories.category_parent_id as parent, k3rbu_virtuemart_categories.ordering as ordering, 2 as level
FROM (((k3rbu_virtuemart_categories
INNER JOIN k3rbu_virtuemart_category_categories
ON k3rbu_virtuemart_categories.virtuemart_category_id = k3rbu_virtuemart_category_categories.category_child_id)
INNER JOIN k3rbu_virtuemart_categories_de_de
ON k3rbu_virtuemart_categories.virtuemart_category_id = k3rbu_virtuemart_categories_de_de.virtuemart_category_id)
LEFT
OUTER JOIN k3rbu_virtuemart_category_medias
ON k3rbu_virtuemart_categories.virtuemart_category_id = k3rbu_virtuemart_category_medias.virtuemart_category_id)
LEFT
OUTER JOIN k3rbu_virtuemart_medias
ON k3rbu_virtuemart_category_medias.virtuemart_media_id = k3rbu_virtuemart_medias.virtuemart_media_id
WHERE k3rbu_virtuemart_category_categories.category_parent_id = 212
AND k3rbu_virtuemart_categories.published = 1
ORDER BY k3rbu_virtuemart_categories.ordering ASC, k3rbu_virtuemart_categories.virtuemart_category_id ASC

Doppelte Abfragen: #91
SELECT *, k3rbu_virtuemart_categories.virtuemart_category_id as id, k3rbu_virtuemart_category_categories.category_parent_id as parent, k3rbu_virtuemart_categories.ordering as ordering, 2 as level
FROM (((k3rbu_virtuemart_categories
INNER JOIN k3rbu_virtuemart_category_categories
ON k3rbu_virtuemart_categories.virtuemart_category_id = k3rbu_virtuemart_category_categories.category_child_id)
INNER JOIN k3rbu_virtuemart_categories_de_de
ON k3rbu_virtuemart_categories.virtuemart_category_id = k3rbu_virtuemart_categories_de_de.virtuemart_category_id)
LEFT
OUTER JOIN k3rbu_virtuemart_category_medias
ON k3rbu_virtuemart_categories.virtuemart_category_id = k3rbu_virtuemart_category_medias.virtuemart_category_id)
LEFT
OUTER JOIN k3rbu_virtuemart_medias
ON k3rbu_virtuemart_category_medias.virtuemart_media_id = k3rbu_virtuemart_medias.virtuemart_media_id
WHERE k3rbu_virtuemart_category_categories.category_parent_id = 212
AND k3rbu_virtuemart_categories.published = 1
ORDER BY k3rbu_virtuemart_categories.ordering ASC, k3rbu_virtuemart_categories.virtuemart_category_id ASC

ok I see
I will check by my side if I can find some duplicates when using it
Remind me in 1 week if you don't hear back from me
CEd