WooCommerce Performance — Keep Your Store Fast at Scale

## Why WooCommerce Gets Slow WooCommerce is built on WordPress, which stores everything in two database tables: wp_posts and wp_postmeta. Products are posts. Orders are posts. Variations are posts. Every piece of metadata — price, SKU, weight, dimensions — is a row in wp_postmeta. When you have 1,000 products with 5,000 variations and 10,000 orders, wp_postmeta has hundreds of thousands of rows. Every page view queries this table multiple times. Performance degrades. ### The Hosting Foundation **Dedicated PHP workers.** WooCommerce needs dedicated resources, not shared hosting where your store competes with hundreds of other sites for CPU time. **Redis object caching.** WooCommerce makes 100+ database queries per page view. Object caching stores query results in memory so they don't hit the database repeatedly. This alone can cut page generation time in half. **Selective page caching.** Cache product pages, category pages, and the homepage. Never cache the cart (/cart/) or checkout (/checkout/) — those need to be dynamic. Server-level caching (Nginx FastCGI) is 5-15x faster than plugin caching. ### Product Catalog Optimization **Compress all images before upload.** Convert to WebP format at 80% quality. Resize to maximum 1600px wide. A typical product image should be 50-150KB, not 2-5MB. **Limit variations.** A product with 50 variations (5 colors × 10 sizes) creates 50 additional posts in the database. If possible, split into separate products or reduce options. **Paginate product listings.** Show 20-30 products per page, not 100. Infinite scroll loads all products eventually, defeating the purpose. ### Database Optimization **Enable HPOS** (High Performance Order Storage) in WooCommerce 8.2+. This moves orders out of wp_posts into dedicated tables — dramatically faster for stores with thousands of orders. **Add wp_postmeta indexes.** WooCommerce queries meta_value frequently but it's not indexed by default. Adding an index on meta_value can speed up product queries significantly. **Archive old orders.** Completed orders from 2+ years ago rarely need to be queried. Move them to an archive to keep the active tables lean. ### The Result A well-optimized WooCommerce store on managed hosting handles 50,000+ products and thousands of daily orders. The secret isn't plugins — it's infrastructure and database optimization.