I have to say that I am really happy with your plugin and expertise.
I have read a lot of your blogs and have found them really interesting.
I saw on the product page of scalability pro that when we have a webshop on a dedicated server with more than 5000 products / orders / posts and the website is still slow that you can have a look at why scalability isnt working.
We do have around 2k orders, and 3.5k - 4k products with LOTS of variations.
I also have installed redis for object caching like I saw in your blog post.
However on the website we do experience some slow loading archive pages.
Some days it fast (also because of cache) and other days it is really slow.
I hope you can help us further to find a solution for this problem.
It sounds like your object cache is flushing. You should check /etc/redis/redis.conf and look for the maxmemory setting and increase the RAM available to redis.
You should also set an eviction policy – if you have Redis 4.0 or later, you can use this eviction policy:
That would evict the least frequently used keys. I’m not sure how much RAM your server has, but probably your Redis is set to 512MB or something low like that – increasing it to 2GB along with the eviction policy would reduce how often the site is slow.
I looked at the link you shared privately but I couldn’t find products with lots of variations – a mistake people often make is using product variations when product addons or product rules would make more sense – e.g. if choosing an option changes the total price by a specific amount then addons or rules can be used instead of variations, and if an option doesn’t change the price at all then similarly addons or rules can be used. I would need to see the pages you have with lots of variations to help you further.
Feel free to come be the first person in our new #performance-analysis channel on our discord server and we can chat there: