HPOS enabled but WooCommerce is still slow – what HPOS doesn't fix
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
wc_orders_meta: custom fields added by payment gateways, shipping plugins, and anything that callsupdate_meta_data()on an order. Grows with every order.woocommerce_order_itemsand_itemmeta: line items and their attributes. Three to thirty rows per order.wp_comments: order notes. Every status change adds one.
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:
- Order data storage: High-performance order storage — the selected store.
- Enable compatibility mode — if this is on, WooCommerce writes every order to both stores. It is a safety net for the first weeks after switching; left on, it doubles the write cost of every order and keeps
wp_postmetagrowing. Turn it off once your plugins are confirmed compatible.
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
- WooCommerce: High-Performance Order Storage developer docs
- Measurements: OrderArc test store, 100,000 orders, HPOS, October 2026
More guides
- WooCommerce orders page slow? Why it happens with many orders and how to fix it
- Should you delete old WooCommerce orders? Archive vs delete
- WooCommerce database too large: which tables grow and how to shrink them
- How to bulk delete old WooCommerce orders safely (and the reversible alternative)
- WooCommerce "auto archive old orders" feature request: three years later, what are your options