For WordPress VIP and a large commerce prospect, we load-tested WooCommerce at 500K and then 1M products on enterprise infrastructure. We found and fixed the slow queries and indexing bottlenecks, contributed CLI batching fixes upstream, and moved catalog queries to Elasticsearch.
The results became a public WordPress VIP engineering post: “Scaling a High-Volume WooCommerce Shop With Enterprise Search”.