MaximenuCK duplicate queries with VM3

More
10 years 11 months ago #31430 by Otto
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

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #31437 by ced1870
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

Joomlack Webmaster and Developer

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #31440 by Otto
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"

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #31441 by ced1870
where do you see these duplicate queries ? do you have some examples ?

Joomlack Webmaster and Developer

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #31452 by Otto
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

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #31453 by ced1870
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

Joomlack Webmaster and Developer

Please Log in or Create an account to join the conversation.

Time to create page: 0.249 seconds

Fast and powerful creation, customizable and responsive.

Read More

We have 5419 guests and no members online