Can you explain the exact database bottlenecks we might hit when scaling WooCommerce past one million active product SKUs without custom sharding?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
Can you explain the exact database bottlenecks we might hit when scaling WooCommerce past one million active product SKUs without custom sharding?
4 real searches · 1 real-search pass
WooCommerce database schema products wp_posts wp_postmeta lookup tables performance scaling large catalog million productsGoogle ↗
OBSERVED
WooCommerce product lookup tables wc_product_meta_lookup wc_product_attributes_lookup documentationGoogle ↗
OBSERVED
WordPress database schema wp_postmeta indexing performance metadata queries WooCommerce large storesGoogle ↗
OBSERVED
WooCommerce HPOS order tables documentation product catalog database scalingGoogle ↗
OBSERVED
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
Classifying 4 queries…
Searches and sources
ChatGPT4 real searches · gpt-6
WooCommerce database schema products wp_posts wp_postmeta lookup tables performance scaling large catalog million products Google ↗
WooCommerce product lookup tables wc_product_meta_lookup wc_product_attributes_lookup documentation Google ↗
WordPress database schema wp_postmeta indexing performance metadata queries WooCommerce large stores Google ↗
WooCommerce HPOS order tables documentation product catalog database scaling Google ↗
- Installed Taxonomies and Post Types Documentation · woocommerce.com
- Search your WooCommerce site database · woocommerce.com
- An optimization for the product attributes lookup table is coming Roadmap · developer.woocommerce.com
- Installed Database Tables Documentation · woocommerce.com
- Database Description · woocommerce/woocommerce Wiki · github.com
- High-Performance Order Storage Documentation · woocommerce.com
- High Performance Order Storage (HPOS) · developer.woocommerce.com
Queries
4 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
WooCommerce database schema products wp_posts wp_postmeta lookup tables performance scaling large catalog million products OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
WooCommerce product lookup tables wc_product_meta_lookup wc_product_attributes_lookup documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
WordPress database schema wp_postmeta indexing performance metadata queries WooCommerce large stores OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
WooCommerce HPOS order tables documentation product catalog database scaling OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |