OrderArc › Guides

HPOS enabled but WooCommerce is still slow – what HPOS doesn't fix

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

HPOS fixes the order list. It does not fix order search, exports, or anything that joins order items and meta, because those tables grow without limit and HPOS does not change them. If you switched to HPOS and the Orders screen is fast but search or reports still crawl, this is why.

What HPOS changed

Before: an order was a post. Its 30-odd fields were rows in wp_postmeta, mixed with every product and page field on the site. Listing orders meant joining that table against itself.

After: orders live in wc_orders, addresses in wc_order_addresses, operational fields in wc_order_operational_data, each with indexes for the columns the list screen filters by. Listing and filtering by status or date became index lookups.

Measured on a test store with 100,000 orders: the order list loads in 0.8 s under HPOS. That part works.

What HPOS did not change

Order search reads all of them: it matches the term against meta values, addresses, item names. On the same test store, a search by customer email under HPOS did not finish: the server cut the query at 40 seconds.

Exports, custom reports, "customer lifetime value" plugins, and ERP connectors do the same joins and hit the same wall.

Check that HPOS is actually in charge

WooCommerce → Settings → Advanced → Features. Two settings matter:

If the compatibility report (same screen) lists an incompatible plugin, WooCommerce may have refused the switch and you are still on legacy storage without knowing.

The fix for the part HPOS leaves

Keep only recent orders in the live tables. Archiving moves orders older than a threshold, with their items, meta and notes, into archive tables in the same database. The live _itemmeta, _orders_meta and comments tables shrink to the size of recent business, and search, exports and reports speed up with them.

OrderArc works on HPOS stores with or without compatibility mode, and on legacy stores. On the test store it archived 95,922 orders older than a year in 11 minutes in the background; order search went from timing out to under a second. WooCommerce Analytics keeps full history because the stats tables are never moved.

Install it from WordPress.org: OrderArc – Order Archive for WooCommerce.

Sources

More guides