WooCommerce Performance

Overview

WooCommerce performance problems typically stem from five sources: expensive product queries with un-indexed meta tables, unbounded AJAX cart/checkout calls, missing persistent object cache, bloated wp_options autoload data, and a growing wp_woocommerce_sessions and order table without cleanup. This skill covers profiling, query optimization, Redis object caching, and scheduled maintenance routines.

When to Use This Skill

• When store pages are slow to load under moderate traffic (hundreds of concurrent users)
• When server CPU spikes during WooCommerce AJAX calls (add-to-cart, shipping calculation)
• When MySQL query time shows in New Relic or Query Monitor as the primary bottleneck
• When the wp_options table autoload size exceeds 1–2 MB
• When wp_woocommerce_sessions has millions of rows slowing down session lookups
• When implementing Redis or Memcached to reduce MySQL load on a high-traffic store

Core Instructions

1. Profile first with Query Monitor