Over 2.5 million rows post_meta with Facetwp
I wonder if Scalability Pro is for me. I host a WooCommerce website with over 60.000 products. 50.000 posts in a single custom post_type. A taxonomy with about 50.000 terms. It's using Litespeed and Facetwp for faceted dropdown. This facetwp's faceted dropdown works really slow.
Will Scalability Pro improve the speed of this site?
The way FacetWP works is pretty poor to be honest and it’s no wonder it’s slow if you look at their underlying code – they basically load your entire database into an object – this works really well and fast below 5000 products or so, but above that it’s very difficult to make that code pattern work fast.
I recommend you take a look at my Faster Woo Widgets plugin to handle your filters instead. The way it has been coded makes it scale to millions of products with sub-second filtering.
Can you also edit your question and explain more about your 50,000 terms in your taxonomy? That’s quite a lot – should still be fast – the thing that’s difficult to optimise in this area would be if you have 50,000 taxonomies.