QTpro

[radhavallabh]

Hi dear;
I am using 1.0.8.15 and
on my loaded attributes products shop the loading speed of admin/catalog.php was 15.06 seconds and products_attributes.php takes more longer(after editing 2 attributes it gives max_connection_error).

After debugging and checking the queries log it came to my notice dear that QTPro was causing this,
because when I uninstalled the QTPro module and removed its hooks the categories load in 0.6seconds , even the products_attributes.php loads fine.

Can something can be done to reduce the loading speed and many queries this module makes to the database?
As this will cause many issues while the use of the module dear....

Please can you help fix this issue dear...
Awaiting your valuable help and reply;
Thank you again;
Very Warm Regds./
radhavallabh

[raiwa]

What may slow down the load on these 2 pages, specially if you have a lot of products and tracked options, is the attributes stock check for data integrity.
This is triggered each time one of these pages (catalog.php and product_attributes.php) is loaded.
They are called in the admin siteWide hook:
includes\hooks\admin\siteWide\swQtPro.php
You can remove this hook to check if this solves the problem of slow page loads. The other code in this hook only checks if the required qtpro hook and module is installed.

However you should go to the Admin: Tools: Qtpro Doctor page from time to time to check the attributes stock data integrity.

[radhavallabh]

What may slow down the load on these 2 pages, specially if you have a lot of products and tracked options, is the attributes stock check for data integrity.
This is triggered each time one of these pages (catalog.php and product_attributes.php) is loaded.
They are called in the admin siteWide hook:
includes\hooks\admin\siteWide\swQtPro.php
You can remove this hook to check if this solves the problem of slow page loads. The other code in this hook only checks if the required qtpro hook and module is installed.

However you should go to the Admin: Tools: Qtpro Doctor page from time to time to check the attributes stock data integrity.

Thank you dear! That does fixes the issue entirely
Will surely keep in mind to check the Qtpro Doctor page from time to time
Very Warm Regds./
radhavallabh

[ecartz]

Given the nature of the query, it might suffice to replace the products_id index on products_attributes with a compound index on products_id, options_id, options_values_id. That might speed up that query enough that you can run it frequently. Note that I haven't done that, so I can't say what will happen only speculate as to what might happen. Testing would be needed.

[radhavallabh]

Given the nature of the query, it might suffice to replace the products_id index on products_attributes with a compound index on products_id, options_id, options_values_id. That might speed up that query enough that you can run it frequently. Note that I haven't done that, so I can't say what will happen only speculate as to what might happen. Testing would be needed.

Thank you for the awesome tip dear, shall surely try the same!
Very Warm Regds./
radhavallabh

[raiwa]

I have no sample database with an amount of products/attributes to get significant slow queries for testing.

[lecarlb]

Raiwa,

I was also having issues with attributes and catalog pages in admin loading slowly. So I removed includes\hooks\admin\siteWide\swQtPro.php as suggested and now the stock isn't able to be tracked thus the Stock Table doesn't appear on the product page. Is there a workaraound or is it just a trade off for faster loading?

Just in case you didn't know

[raiwa]

I checked in my test store and this hook doesn't have an influence on the public store side - product page. It's an admin hook.
I get the stock table shown on product pages despite having the hook temporary removed.

[lecarlb]

So I got to figure out why it's not showing. I have only one attribute on my test product and have multiple drop-down selected in QTPro Options.

Thank you.