Complaint 30 of 43
Order data does not scale
On older WooCommerce shops every order is one database row plus roughly 29 more, one guide reports. At 50,000 orders that is more than 1.4 million rows.
The short answer: The Hostless Duck Store module keeps orders in its own tables; it has not been tested at tens of thousands of orders, and we do not claim it has.
The pain
On older shops each order is one row plus about 29 more. At 50,000 orders that is more than 1.4 million rows.
Who feels it most: Growing shops.
Why it happens
- WooCommerce first stored an order the way WordPress stores a blog post, with each detail of the order attached as a separate row. Source: Intense Path
- Those rows share a table with every revision, attachment and product attribute on the site, so finding one order means searching all of it. Source: Intense Path
- WooCommerce now offers dedicated order tables. A shop that began on the old storage has to switch over, and one guide says that on a shop with only a few hundred orders the gain is minor. Source: Rerealize
What it costs
- The queries WooCommerce runs during checkout slow down as the rows pile up. Source: Rerealize
- The order list and order search in the admin slow with them. Source: Rerealize
- The table of background jobs grows as well: on a busy shop faster than the order table does. Source: Intense Path
How Hostless Duck is built differently
The Store module keeps orders in its own tables. It has not been tested at tens of thousands of orders, and we do not claim it has.
The live module: Store Core.
Using a plugin for this today? See what carries over from WooCommerce.
Sources
| Source | What kind | Last read |
|---|---|---|
| Rerealize: "WooCommerce Store Slow? Fix Ecommerce Speed" | Secondary: a vendor or a competitor | 21 November 2026 |
| Intense Path: "WooCommerce Performance at Scale: What Breaks" | Secondary: a vendor or a competitor | 21 November 2026 |
Found a link that no longer says what we say it does? That is a fault in this page, and we would rather fix it than defend it.
The other articles
Does your site have this one?
Give us your site's address and we read its public pages once: its theme, its plugins, and what Hostless Duck has for each. A real scan of your public pages, never a made-up result. No card.

