Open lkraav opened 1 year ago
Indeed this is the same issue as order search -- the notorious nonsargable column LIKE '%searchterm%'
performance antipattern.
Thoughts on getting this in? Do you need a copy of the plugin perhaps?
Is this already fixed with https://github.com/OllieJones/fast-woo-order-lookup/blob/d945f3fd7a86a97b2c37e83a01883975d6c36c0b/fast-woo-order-lookup.php#L112 :thinking:
Exactly the same thing is happening at https://github.com/Automattic/woocommerce-subscriptions-core/issues/183