WooCommerce – Slow Order Search

Hey everyone,

Looking to improve my search time whenever it comes to WooCommerce->Orders. We have 120,000 orders, and the search time is pretty awful. Here is my base line test (done on localhost):
-Search by order number – 25 seconds
-Search by name – 50 seconds
-Search by Email – 55 seconds

After much searching, I didn’t see many viable options (outside of using a third party service). So I decided to make some changes to the queries in the plugin itself (purely for testing). I was able to reduce search times to the following:
-Search by order number – 6 seconds
-Search by name – 9 seconds
-Search by Email – 9 seconds

These are much more acceptable times (can probably get better times with more tweaks), but I had to edit a function in the file: woocommerce->includes->admin->class-wf-admin-post-types.php.

I don’t want to edit the plugin file itself, and the function is already declared first by woo commerce, so I can’t call it in my functions.php file. How can I get my changes to take effect?