I use the Woodmart theme on my website. (tested with Storefront theme and the result is the same) I have over 400k products and there was a clone of my website that I used smoothly when I had 100k products in the test environment. I have a powerful 32 core system
and only 2 websites are hosted on this server. load avarages vary from 25-28. When I check my queries with the Query Monitor plugin, it finds woocommerce as responsible.
SELECT SQL_CALC_FOUND_ROWS 8MIzDi_posts.ID FROM 8MIzDi_posts LEFT JOIN 8MIzDi_postmeta ON ( 8MIzDi_posts.ID = 8MIzDi_postmeta.post_id AND 8MIzDi_postmeta.meta_key = '_headstart_post' ) LEFT JOIN 8MIzDi_postmeta AS mt1 ON ( 8MIzDi_posts.ID = mt1.post_id ) WHERE 1=1 AND ( 8MIzDi_postmeta.post_id IS NULL OR mt1.meta_key = '_edit_last' ) AND 8MIzDi_posts.post_type = 'product' AND ((8MIzDi_posts.post_status = 'publish')) GROUP BY 8MIzDi_posts.ID ORDER BY 8MIzDi_posts.post_date DESC LIMIT 0, 10
Hello @barisyildirimc the issue here is most likely due to the sql not being able to serve the request fast enough. Do you know if you have Redis or Memecache enabled on the server? Who are you hosted with?
I understand you are experiencing a performance issue related to the number of products you have on your WooCommerce site.
WooCommerce is designed to handle large product databases, there could be some performance issues when dealing with such a high volume since it involves some intensive database queries, particularly when dealing with large numbers of products.
To help alleviate this, you might want to consider implementing some performance optimization strategies. This could include using a caching plugin.
I tried to install redis on the server a couple of times, but I got “Error establishing a Redis connection” in redis, although I made the necessary adjustments many times, I could not get it to work stably. If you have any idea about this issue, I would be happy to hear it.
Can you please tell me about the areas I need to improve? My website has been live for a while and I used to have a really satisfactory order volume but now the performance is affecting my sales a lot. Can you help?
I understand that you’re experiencing some performance issues with your WooCommerce site, particularly due to the large volume of products.
First, I recommend optimizing your database. Various plugins are available that can clean up your database by removing unnecessary data like spam comments, trash posts, etc. A popular choice is the WP-Optimize plugin.
Next, to improve website loading speed, I recommend using a cache plugin like Jetpack Boost, WP Rocket, Flyting Press, Perfmatters, etc. And don’t forget about a CDN – Cloudflare is a great option, but there are plenty of others out there, too.
Furthermore, the Redis issue is hard to diagnose without more information. However, common issues include an incorrect configuration in the wp-config.php file, a firewall blocking the connection, or the Redis server not running. You may need to consult with a server or database specialist to look into this.
I hope these suggestions help improve your site’s performance. If you have any further questions or need additional assistance, please don’t hesitate to ask.
I am already implementing many of the suggestions you mentioned on my website.
I use the WP-Rocket plugin for caching. In addition, this plugin has a feature to optimize the database and I use it. I aim to use as few plugins as possible, I think that using too many plugins is bad for speed. If the database optimization in WP-Rocket is insufficient, please tell me I can use the WP-Optimize plugin.
For CDN I use https://bunny.net/ I also use Cloudflare but I don’t use Cloudflare for CDN, is that enough for me? Should I use Cloudflare?
I am already implementing many of the suggestions you mentioned on my website.
I use the WP-Rocket plugin for caching. In addition, this plugin has a feature to optimize the database and I use it. I aim to use as few plugins as possible, I think that using too many plugins is bad for speed. If the database optimization in WP-Rocket is insufficient, please tell me I can use the WP-Optimize plugin.
For CDN I use https://bunny.net/ I also use Cloudflare but I don’t use Cloudflare for CDN, is that enough for me? Should I use Cloudflare?
I will make adjustments for the things you mentioned for Redis. Thank you.I will make adjustments for the things you mentioned for Redis. Thank you.
It’s great to hear that you’re already implementing many of the suggestions.
The WP-Rocket plugin is an excellent choice for caching, and its database optimization feature is generally quite efficient. However, if you’re still experiencing performance issues, it may be beneficial to try the WP-Optimize plugin for a more thorough database clean-up.
In terms of CDN, both Bunny.net and Cloudflare are good options. If you’re already using Bunny.net and are happy with its performance, there’s no immediate need to switch to Cloudflare. However, Cloudflare offers additional features like DDoS protection and image optimization, which might benefit your site.
I’m glad to hear you’re making adjustments to the Redis issue. If the issue persists, it could be beneficial to contact a server or database specialist to ensure everything is configured correctly.
I hope this helps! If you have any further questions or if there’s anything else you need assistance with, please don’t hesitate to ask.
