Open products works at the usual speed for me. Consider the debug procedure: Deactivate plugins and try the default theme to try to identify the element that’s causing the problem..
Thread Starter
Lakjin
(@lakjin)
The theme and other plugins is not the issue. WordPress 4.2 made some change that is effecting WooCommerce.
How many products and purchases do you have? Your WooCommerce database may be small enough to not feel the change. I have over 1,000 products and over 1,000,000 purchases.
Thread Starter
Lakjin
(@lakjin)
This is the query that is taking so long while opening posts:
SELECT meta_key
FROM wp_postmeta
GROUP BY meta_key
HAVING meta_key NOT LIKE '\\_%'
ORDER BY
Since the wp_postmeta table is so large for me, this query is taking forever to finish. Any way to optimize this? This seems like a new change in WP 4.2, i didn’t happen before.
I have a small shop. Hopefully someone else can help here.
Totally agree, i deactivated all plugins including woocommerce, changed theme and still everything was stupidly slow.
I even set up a new subdomain adding a fresh install off woocommerce and wordpress with just 1 product in the cart! Still Slow!
It seems that wordpress 4.2 is just slow as hell as all older versions on the server are fine!
On my site everything also runs very slow. I also have around 1000 products and al lot of purchases. So I follow this topic.
I have the same problem…. After update woocommerce, my site is intermitent.
Cant acces to wp-admin (get error 500) and in my error log appear this:
[28-Apr-2015 15:14:26 UTC] Error Lost connection to MySQL server during query de la base de datos de WordPress para la consulta SELECT mf_posts.ID FROM mf_posts INNER JOIN mf_postmeta ON ( mf_posts.ID = mf_postmeta.post_id ) INNER JOIN mf_postmeta AS mt1 ON ( mf_posts.ID = mt1.post_id ) INNER JOIN mf_postmeta AS mt2 ON ( mf_posts.ID = mt2.post_id ) WHERE 1=1 AND mf_posts.post_parent = 0 AND (
mf_postmeta.meta_key = ‘total_sales’
AND
(
( mt1.meta_key = ‘_visibility’ AND CAST(mt1.meta_value AS CHAR) IN (‘visible’,’catalog’) )
AND
( mt2.meta_key = ‘_featured’ AND CAST(mt2.meta_value AS CHAR) = ‘yes’ )
)
) AND mf_posts.post_type = ‘product’ AND ((mf_posts.post_status = ‘publish’)) GROUP BY mf_posts.ID ORDER BY mf_postmeta.meta_value+0 DESC LIMIT 0, 5 realizada por require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/woocommerce/templates/single-product.php’), do_action(‘woocommerce_after_main_content’), call_user_func_array, woocommerce_output_content_wrapper_end, wc_get_template, include(‘/themes/mindig2/woocommerce/global/wrapper-end.php’), yit_primary_sidebar, yit_get_template, include(‘/themes/mindig2/theme/templates/primary/sidebar.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Products->widget, WC_Widget_Products->get_products, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
please someone of woocommecre to solve this…
I have the same problem with my woo-commerce site. After rolling back to WP 4.1.4 I can finally load the product pages. They were timing out after WP was updated to 4.2.x.
I also have a lot of products (approx 1600) so maybe it’s not showing up on smaller shops.
Woo-commerce is broken.
Hi,
I’m also experiencing similar issues. I’ve added query monitor plugin and noticed that archive and product pages are making 500-1000 db queries. Maybe that’s what causing the issue. Is there any way to reduce the number of queries?
Thanks
Thread Starter
Lakjin
(@lakjin)
It’s coming from this function in WordPress core:
https://dl.dropboxusercontent.com/s/ud3ax1xhkmktbbl/2015-04-30%20at%2014.50%202x.png?dl=0
But this has not changed since 4.1 so I don’t see how it can be that: https://core.trac.wordpress.org/browser/tags/4.1.4/src/wp-admin/includes/template.php#L643
Have you installed query monitor to see what else it could be?
https://wordpress.org/plugins/query-monitor/
I don’t know why it is happening after WordPress 4.2 update, but Query Monitor shows it is indeed the culprit:
SELECT comment_approved, COUNT( * ) AS num_comments
FROM wp_comments
WHERE comment_type != 'order_note'
GROUP BY comment_approved
8.7224 secs
SELECT post_status, COUNT( * ) AS num_posts
FROM wp_posts
WHERE post_type = 'shop_order'
GROUP BY post_status
4.1467 secs
SELECT meta_key
FROM wp_postmeta
GROUP BY meta_key
HAVING meta_key NOT LIKE '\\_%'
ORDER BY meta_key
LIMIT 30
201.8540 secs
Same problem here, the website is sooo slow since I updated to the new version of wordpress. Also the server goes off every couple of minutes with an error message 500.
Hi Jimmy_xs, until they can find a fix for WP 4.2, just roll back to WP 1.4.1 I did and that worked for me.
I’m not crazy about using an old version of WordPress but I’ve also installed Wordfence and Cloudflare in an effort to secure my website.
Thread Starter
Lakjin
(@lakjin)
Anyone find a solution to this? Having to wait 5 – 10 mins to open a product is getting annoying, very quickly.
I know Claudio has been looking into this but so far unable to find a cause, mainly due to that function not changing between 4.1.x and 4.2.x. If someone could send an export (tools > export) of their products to mike.j[at]woothemes.com we can import that and see if there is anything erroneous/if it happens on another install.
