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, not your theme or your hosting plan. The storefront is cached; the admin is not.
I measured this on a test store with 100,000 orders and 20,000 refunds. Here is what I found.
First, time three screens
- The order list (first page, no filters).
- A search by customer email.
- Opening a single order.
| Slow | Fast | Likely cause |
|---|---|---|
| List and search | Single order | Legacy order storage (orders in wp_posts / wp_postmeta) |
| Search only | List, single order | Order volume |
| Every admin screen | Storefront | A plugin running heavy queries in the admin |
Cause 1: legacy order storage
Before WooCommerce 8.2, every order was a post and every field was a row in wp_postmeta. Switching to High-Performance Order Storage (HPOS) moves orders into proper tables with indexes: WooCommerce > Settings > Advanced > Features. Test it on staging first; a few old extensions still read wp_posts directly.
Cause 2: volume (HPOS doesn't fix this one)
With HPOS on the 100K-order store, the list loaded in 0.8 s, but a search by email did not finish: the server cut it at 40 s with a 500 error. Search still has to go through every order's addresses, items and meta.
The fix is to keep only recent orders in the live tables. You can:
- Delete old orders. Fast and permanent. You also lose the history that refunds, accounting and repeat-customer lookups rely on.
- Archive them. Move completed and cancelled orders older than N months into archive tables in the same database, where they can still be searched, viewed and restored.
What archiving did on the test store
I wrote a free plugin for the second option, OrderArc. On the test store:
- Archiving everything older than a year (about 96,000 orders) ran in the background in 11 minutes, with the order list still loading in 1.0-1.2 s during the run.
- After it, WooCommerce's own order search went from never finishes to 0.2 s.
- WooCommerce Analytics kept all its history, because the stats tables are never touched.
- Restoring everything and comparing every table against a fingerprint taken before: zero differences.
Archived orders stay visible in the admin (with search and one-click restore) and customers still see them under My Account. It works with HPOS, with or without sync, and with legacy storage. Nothing leaves your database.
It is on WordPress.org: OrderArc – Order Archive for WooCommerce.
What will not help
- Caching plugins. The admin is never cached.
- A bigger server. It turns a 40-second search into a 20-second one.
- Deleting products or images. They live in different tables.
More detail (including how to spot cause 3 with Query Monitor) is in the guides at getorderarc.com/guides.
Disclosure: I'm the author of OrderArc.
Top comments (0)