Support

Search results for ""

Sorry, no results found. Perhaps you would like to search the documentation?
All Topics
admincolumnspro

Slow-loading products page with ac-addon-woocommerce enabled

Hello,

I just updated to 3.5.10 hoping that it would speed up the 59s load on my products page. There are multiple queries similar to the one below (which takes 3.5s). I counted 20 such queries. Is there a config setting that I have wrong? Disabling the plugin fixes the problem entirely.

Thanks for your assistance.

SELECT DISTINCT pm.meta_value AS cid
FROM wp_postmeta AS pm
INNER JOIN wp_posts AS p
ON p.ID = pm.post_id
AND p.post_status = ‘wc-completed’
INNER JOIN wp_woocommerce_order_items AS oi
ON oi.order_id = p.ID
AND oi.order_item_type = ‘line_item’
INNER JOIN wp_woocommerce_order_itemmeta AS oim
ON oi.order_item_id = oim.order_item_id
AND oim.meta_key = ‘_product_id’
WHERE pm.meta_key = ‘_customer_user’
AND oim.meta_value = 112030

4 months, 2 weeks ago
Stefan
Developer

Thanks for your feedback.
I suspect that you’re using the Customer column on the product page.
Although this is a useful column, it can slow down the performance of the product page when you have many orders and customers on your website. In your case, I recommend removing this specific column or if you really need that column, you could show fewer items on the page to speed up the loading time.

4 months, 2 weeks ago

You must be logged in to reply to this topic.