Thanks for the kind words. And, thanks for telling me about your success on your large store. It’s good to know this worked scaled up to 7+ megarows in wp_postmeta.
Your uploaded monitor doesn’t suggest anything dramatic about other optimizations. But, for what it’s worth, you ran the monitor before you added the plugin’s high-performance keys. You might try another monitor after enabling the keys.
> It’s good to know this worked scaled up to 7+ megarows in wp_postmeta.
We have 10M rows in wp_postmeta, and after getting the wp_postmeta performance index built y-day (had to reconfigure tmpdir off /tmp, which at 2.6G free still ran out of space),
query speed increase was absolutely mind-blowing.
We had 20-30-40s queries go down to 1s and less (WC orders, subscriptions etc)
I’m most confused on, why isn’t this in WooCommerce core yet.
I’m going to open that discussion with WC team.
> I’m most confused on, why isn’t this in WooCommerce core yet.
I’m confused too why this isn’t in Woocommerce core..
Please ask them and update this post.
> You might try another monitor after enabling the keys.
Please check the new 10min monitor with the keys enabled.. (id dY8YQJZq)
PS. i also enabled redis object cache after new keys.
Thank you!
-
This reply was modified 2 years, 2 months ago by malakontask.