Nothing Gained

Scott Marshall asked 2 months ago

This has not improved anything significant. Takes 60 plus seconds to load a product page. We have alot of variations but nothing out of the ordinary for apparel options. I'm using your plugins, caching plugin, image reducing plugin. I'm at a loss.

1 Answers
Dave Hilditch Staff answered 2 months ago

Looking at your /product-category/astrology/ page with Query Monitor, I see a very high RAM usage in Query Monitor.

When I click to view Queries then sort by ‘Row Count’ then I see a couple of queries populating the cache consuming 40,000+ rows.

High row count leading to high RAM usage

When you have a lot of variations, many themes and plugins and even vanilla woocommerce will load the underlying product variations on the archive view. Whether it’s just the product IDs of these variations or more detail that is loaded depends on the plugins, theme, theme features and even shortcodes and widgets you use.

Firstly, to improve your situation you should definitely go about installing an object cache. An object cache helps here because vanilla WooCommerce will definitely continue to load these underlying variations for each product. Without an object cache, even if this product appears on another archive page the data will need to be refetched. With an object cache, the cache per product persists from page to page so you’ll start seeing far faster page loads.

Scalability Pro doesn’t yet help with product variations on the archive page – it helps with the main slow running queries (e.g. WP_Query on archive pages). So in this case you should add an object cache and report back in the comment area below or update your question.

There’s more info here about identifying the cause of your bottleneck:

https://www.wpintense.com/performance

Subscribe!

We publish performance optimisation guides regularly.

Subscribe so you never miss out.

We use cookies

We use cookies for various things on our site, including our on-site chat bubble (if you use it), our comment forms (if you use them) and for session handling (if you log in).

Other than that, we use cookies to identify where traffic came from to help us understand which traffic turns into sales, we use a cookie for Google Analytics traffic analysis and we use a cookie to customise adverts for our own products we think you'll be interested in.

You can read more detail in our privacy policy page. Please click 'Accept' or 'Decline' to continue.