Skip to the main content
Menu

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.

Sources read 21 November 2026Shops

The figures

  • roughly 29

    extra database rows stored beside every order on older WooCommerce shops

    Rerealize
  • more than 1.4 million

    rows at 50,000 orders on that older storage

    Rerealize

Each figure was read at its source on 21 November 2026. They are other people's measurements, not ours.

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

What Hostless Duck does about it Partly, and we say where it stops

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

Sources for "Order data does not scale"
SourceWhat kindLast read
Rerealize: "WooCommerce Store Slow? Fix Ecommerce Speed"Secondary: a vendor or a competitor21 November 2026
Intense Path: "WooCommerce Performance at Scale: What Breaks"Secondary: a vendor or a competitor21 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.

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.

The Duck giving a thumbs-up