search

Vinai / groupscatalog2

Magento extension to enable you to hide categories and products from customers depending on their customer group. This is a Magento 1.6 and newer compatible version of the Netzarbeiter Customer Groups Catalog extension.
139 stars 60 forks source link

Heavy Database Load #22

Closed Vinai closed 11 years ago

Vinai commented 11 years ago

Quote from Email: Hello we would like to use your very nice module Group Catalog2. We're running Magento 1.7.0.2, it's 1 store with 3 storeviews (3 languages). When we installed your module everything is working perfect, however the database load is becoming very high so our hosting provider doesn't like it :) .

Is there any way to fix this, or could you help us to resolve this problem?

Vinai commented 11 years ago

After the initial reindex the load shouldn't really noticeable differ with or without the extension. Only a simple join on a table on indexed column's is made.

Maybe there is some issue with the table indexes - do you have the mysql slow query log enabled? If so, please send me a couple of example queries that include the joins to the groupscatalog_product_idx and groupscatalog_category_idx tables.

In addition to the queries, please send me the output of the query prefixed with the MySQL command "EXPLAIN ", to show how the query optimizer attempts to run the select.

Vinai commented 11 years ago

Resolved via email response: building the indexes solved the issue.