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
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.
You must be logged in to reply to this topic.