wc_customer_bought_product() slows down page massively
-
Hi,
the wc_customer_bought_product() function slows down product pages massively. It can take up to 60 seconds (!!!) to load the page, which is absolutely inacceptable. It took me ages to find out what was going on.
A similar issue was reported on Github. It was tagged as resolved, but it is not resolved at all. The problem does not occur if the user is not logged in.
This is a typical log of the Query Monitor plugin:
SELECT im.meta_value FROM bi4a6hmggc_posts AS p INNER JOIN bi4a6hmggc_postmeta AS pm ON p.ID = pm.post_id INNER JOIN bi4a6hmggc_woocommerce_order_items AS i ON p.ID = i.order_id INNER JOIN bi4a6hmggc_woocommerce_order_itemmeta AS im ON i.order_item_id = im.order_item_id WHERE p.post_status IN ( 'wc-processing','wc-completed' ) AND pm.meta_key IN ( '_billing_email', '_customer_user' ) AND im.meta_key IN ( '_product_id', '_variation_id' ) AND im.meta_value != 0 AND pm.meta_value IN ( '384130','sdfsfdasf' )No comes the weird part: It does not to depend on the total amount of reviews. We see these extremely slow queries no matter whether a product has 40 reviews or 400. In addition to that: We don’t see this problem on a freshly cloned copy of the site on a different domain: We cloned both the database and the file system, changed the domain and replaced the domain in the database. No problem at all! How is this possible?
Any ideas would be very appreciated!
Mike
-
Loading the product page took almost 45 seconds. After logging out load time is 2 seconds or so.
Hello @cutu234,
Thank you for reaching out!I’ve just found out that “wp_remote_get()” failed, but is ok on the test site. What does it mean? This is the same server with an identical configuration.
You can ask your hosting provider to help you with this part. :?)
Quick update: It seems that the wc_customer_bought_product() function is not called on the working site clone. What’s going on here? Both sites should be working exactly the same.
The team is already aware of this performance issue, but it shouldn’t take 45 seconds, please check this report for more context: https://github.com/woocommerce/woocommerce/issues/34358
I know this doesn’t happen in the cloned environment, but could you please try performing a conflict test? Perhaps your theme or another plugin is overriding one of these methods:
Link to image: https://d.pr/i/n3Q3IULet us know how it goes!
You can ask your hosting provider to help you with this part. :?)
I did, of course, and my hosting company usually provides great support. They have no idea what that means and told me to contact the manufacturer (of the plugin). That’s funny, isn’t it?
Of course, I already did a conflict test. Couldn’t find any.
The only pattern I can see is that this database query run by the function wc_customer_bought_product() does not show, if loading time is ok. Again, it DOES NOT SHOW at all. Why is that? Why would this database query sometimes run and sometimes not, if everything else is exactly the same?
Can I somehow disable this function for test purposes? As far as I can see this query checks if a user (by email or ID or both) has bought an item. Why running this query on a product page?
Thank you!
Hi there,
I was so happy to see your post, but unfortunately, it doesn’t work. I’ve just tried it in a clean browser (no cache, no history). The code snippet does not change anything. See this screenshot some minutes ago (timezone is Germany):
Removing the function from the core file immediately fixes the problem. I know that this is not an acceptable solution. But 50 seconds page load time on a product page is commercial suicide.
I’m pulling my hair out. I have NEVER EVER had such a nasty problem.
Please note that this is a 3 GB database with millions on entries in the postmeta table. You will not have any problems in a test installation.
I know that Woocommerce scales up poorly. I can live with that in the dashboard, but not on the frontend. And since I don’t use any feature that would need this function, why is it enabled anyway? There is something seriously wrong. Even if I remove this part from the single product template, the function is still running in the background. It drives me literally crazy.
The thing is that this problem is kind of new, we didnot have it a few months ago and the database was the same size then.
I can confirm that. Same here in our shop.
Could you post a list of your plugins? Maybe, we can find a pattern.
Does the problem occur with all other plugins disabled? For us, troubleshooting was insanely tedious. The problem does not always occur even in a 100% clone of the live website.
In our case, the problem occurs for all users, not only for logged in admins. It is so severe that we even got emails from customers complaining about page loading time.
Can you check whether removing the function from the core file fixes the issue?
- The topic ‘wc_customer_bought_product() slows down page massively’ is closed to new replies.
