WooCommerce HPOS Hosting

HPOS hosting for stores whose orders outgrew the posts table.

For fifteen years a WooCommerce order was a post. High-Performance Order Storage moves it to its own tables, and the move itself is the risky part.

Conversion runs to completionSync mode watchedOrder tables indexed
Batch conversionSync monitoringOrder indexingDaily backupsFree SSL24/7 support
Built for order tables

Moving a decade of orders.

The destination is straightforwardly better. Getting there, with a live store, is where the care goes.

A conversion that reaches the last order

Migrating years of orders out of posts and postmeta is far more work than any request allows. It runs as a resumable batch, so a store with a long history finishes rather than stalling mid-decade.

Resumable

Compatibility mode watched, not assumed

During the transition WooCommerce writes to both the old and new storage. That doubles write cost and drifts if a run fails, so it is monitored rather than left on indefinitely.

Drift checked

Order queries that use the new indexes

The point of HPOS is that order lookups stop being meta queries. Those tables get indexes for status, customer and date, which is what admin order search actually filters on.

Extensions that have not caught up

Plugins written against the posts table break quietly under HPOS. We will check your extension list before the switch rather than after somebody cannot find an order.

A restore point before the switch

Converting order storage is not a setting you toggle back casually. A backup is taken before the run, because that is the only clean way out.

Transition

The dangerous window is the middle.

Before HPOS the store works. After HPOS the store works. The risk lives in the period where both storages exist and one of them is quietly falling behind.

  • Conversion run as a resumable batch
  • Dual-write mode monitored for drift
  • Order tables indexed for admin queries
  • Extension compatibility checked before the switch
Orders
To convert
412,000
Sync mode
Dual write
no drift
Order search
Admin
indexed
Conversion
Batch run
running
Order lookups

Admin order search stops being slow.

The reason HPOS exists is that finding an order used to mean querying postmeta. The gain shows up first in the admin, where staff work all day.

Resumable
conversion batches
Monitored
dual-write drift
Indexed
status, customer and date
MagicWP120 ms
Typical shared host1520 ms
Legacy post-based orders640 ms

Illustrative comparison of an admin order search on a large store. Your numbers depend on order count and search criteria.

Configuration

What we change for HPOS

Most of this is about the migration rather than the destination, because the destination is the easy half.

SettingWhat we doWhy
Order conversionResumable batches with progress preservedMoving years of orders out of posts and postmeta cannot complete in one pass, and a run that dies leaves the store split between two storage models.
Compatibility modeMonitored for drift and time-boxedDual writing doubles the cost of every order and silently diverges when a sync fails, so leaving it on permanently is the worst of both designs.
Order table indexesSet for status, customer and date togetherAdmin order search filters on exactly that combination all day, and it is the workload HPOS was introduced to fix.
Extension auditChecked against the plugin list before switchingPlugins written against the posts table fail quietly under HPOS, and the failure surfaces as an order somebody cannot find rather than as an error.
Pre-migration backupTaken immediately before the conversion runChanging where orders live is not a toggle you reverse casually, and a restore point is the only clean exit if the run goes wrong.
Plans

Simple, transparent pricing.

Every plan includes free migration, daily backups, SSL and 24/7 support.

MonthlyYearly 2 months free
Starter
For personal sites, blogs, and portfolios.
$20/mo
  • 1 WordPress site
  • 10 GB NVMe disk
  • Free SSL
  • Daily backups
  • One-click deployment
  • Support tickets
Start free trial
Pro★ Most popular
For growing businesses and busy stores.
$80/mo
  • 5 WordPress sites
  • 50 GB NVMe disk
  • Free SSL
  • Daily backups
  • One-click deployment
  • Priority support tickets
Start free trial
Enterprise
For agencies and high-traffic platforms.
$250/mo
  • 20 WordPress sites
  • 200 GB NVMe disk
  • Free SSL
  • Daily backups
  • One-click deployment
  • Dedicated support
Start free trial
FAQ

Questions, answered.

Is HPOS safe to enable on a large store?
Yes, with the conversion run as a resumable batch and a backup taken first. The risk is not the destination, it is a migration that stops half way and leaves orders in two places.
Should I leave compatibility mode on?
Not indefinitely. Dual writing doubles the cost of every order and drifts when a sync fails, so it is monitored and time-boxed rather than treated as a permanent setting.
Will my extensions still work?
Most will. Plugins written directly against the posts table break quietly, so we check your extension list before the switch rather than after somebody cannot find an order.
What actually gets faster?
Order lookups, and the admin first. Finding an order used to be a postmeta query; with the right indexes on status, customer and date it becomes a direct one.

Move the orders without losing any.

Move the store across — migration is free, conversion handled.