Working well with a large database (46GB)

Using Index WP MySQL for Speed and setting innodb_buffer_pool_size = 4G seems to be working well

Also using this snippet
// Restrict HPOS admin search to core fields to prevent full table scans on wp_wc_orders_meta
add_filter(‘woocommerce_hpos_admin_search_meta_keys’, function($meta_keys) {
// Return an empty array or only essential custom meta keys you frequently search for
return array();
});
This keeps the scan narrow (indexed/high-value keys only) instead of nuking meta search entirely and improves order search speed.