From Dev.to
Why the WooCommerce orders page gets slow with 100K orders (and what actually fixes it)
Your storefront is fast, but WooCommerce > Orders takes ages to open, and searching an order by the customer's email never finishes. That pattern almost always points at the size of the order tables,...
