Support for Product Bundles?

WP Intense Q & ACategory: Scalability ProSupport for Product Bundles?
Dustin Grice asked 6 months ago

Our website is and we are exploring new directions to structure our Woocommerce product data. Curious if Scalability Pro will work with 50,000+ Product Bundles and/or 50,000+ Product Variations? Is one direction with your plugin recommended more than the other? Thanks so much, also do you offer hourly Zoom consulting? -Dustin

1 Answers
Dave Hilditch Staff answered 6 months ago

Scalability Pro speeds up underlying long-running SQL queries. It helps with the underlying main query for /shop/ but if you have 1000s of variations per product then you’ll probably encounter 10,000+ queries per /shop/ page and Scalability Pro doesn’t help with that – the best advice is to keep your variations to fewer than 100 per product so that they can be stored in your object cache.

Product Bundles, on the other hand, they are technically single products so they will be faster. I’m not sure you can achieve the same thing with bundles however.

Generally speaking – use variations ONLY when the price or the image is unique for that option. If it doesn’t change, use a product addon or product option instead. Similarly, if choosing an option changes the price by a predictable value (e.g. small + £0, medium +£10, large +£20) then you can use product options for that too.


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.