OrderArc › Guides

WooCommerce orders page slow? Why it happens with many orders and how to fix it

Last reviewed 8 November 2026 · by Nicolás Alejandro Salinas

If WooCommerce → Orders takes 5-10 seconds to open, or searching an order by email never finishes, the cause is almost always the size of the order tables, not your theme or hosting plan. The storefront can stay fast while the admin becomes unusable, because customer pages are cached and admin pages are not.

First, find out which of the three problems you have

Time these three screens with a stopwatch:

  1. WooCommerce → Orders, first page, no filters.
  2. Searching an order by customer email in that screen.
  3. Opening a single order.

The pattern tells you the cause:

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: search joins every meta row and address
Everything in admin Storefront A plugin running heavy queries on every admin page (activity logs, reporting, multi-vendor)
Everything, storefront too — Server or database, not WooCommerce

Cause 1: legacy order storage

Until WooCommerce 8.2, orders were posts, and every field (email, total, address) was a row in wp_postmeta. Listing 20 orders means joining thousands of meta rows. Switching to High-Performance Order Storage (HPOS) moves orders into dedicated tables with proper indexes.

Where: WooCommerce → Settings → Advanced → Features → Order data storage. If a plugin declares itself incompatible, WooCommerce blocks the switch and names the plugin; update or replace it first. Test on staging: a few old extensions read wp_posts directly and show stale data after the switch.

Measured on a test store with 100,000 orders and 20,000 refunds (legacy storage with sync): the order list went from 3.7 s to 1.2 s and search from 33 s to 1.8 s once the old orders were out of the live tables. HPOS alone fixes the list; it does not fix search at that volume (see cause 2).

Cause 2: order volume

HPOS makes the list fast at any size, but search still scans every order's meta, addresses and items. On the same test store with HPOS, the list loaded in 0.8 s and a search by email did not finish: the server cut it off at 40 s with a 500 error.

The fix is to keep only recent orders in the live tables. Two ways:

OrderArc does the second. On the test store, archiving 95,922 orders older than a year took 11 minutes in the background with the store still serving pages (order list 1.0-1.2 s during the run). After it, search dropped from "never finishes" to under a second. WooCommerce Analytics kept all 119,952 rows of history, because the stats tables are never touched.

Install it from WordPress.org: OrderArc – Order Archive for WooCommerce. It runs on your own database; nothing leaves the server.

OrderArc overview on a store with 4,003 live orders and 95,957 archived: a WooCommerce order search measured at 0.2 seconds
The same 100,000-order store after archiving: 4,003 orders left in the live tables, and WooCommerce's own order search measured at 0.2 s.

What it does not do: speed up the storefront, or shrink the database file (the archive lives in the same database).

Cause 3: a plugin, not the orders

If every admin screen is slow and the orders screen is just the worst, install Query Monitor, open the orders page and sort by query time. The usual suspects:

Deactivate the suspect on staging and time the screen again.

What will not help

Sources

More guides