woocommerce-performance

Start by installing Query Monitor to identify slow and duplicate queries, then enable a Redis persistent object cache, which typically cuts database load by 60-80%. Follow up with HPOS migration and scheduled cleanup of sessions and transients.

Install the redis-cache plugin via WP-CLI, run wp redis enable, and define WP_REDIS_HOST, PORT, DATABASE, TIMEOUT, and MAXTTL constants in wp-config.php. Exclude volatile groups like wc_session_id and counts via WP_REDIS_IGNORED_GROUPS to prevent stale checkout data.

Yes, High-Performance Order Storage moves order data from wp_postmeta into dedicated indexed tables, eliminating a major query bottleneck on WooCommerce 7.1 and later. Audit plugins for direct get_post_meta order calls before migrating.

The sessions table accumulates abandoned guest and bot sessions when no cleanup routine exists. Schedule a daily Action Scheduler job that deletes sessions older than 48 hours in batches of 5000 rows to avoid table locks.

Replace per-product wc_get_product() calls inside loops with a single wc_get_products() query using the include parameter. Combine this with fragment caching of rendered HTML using wp_cache_set with a defined group and TTL.

A low cache hit rate usually means keys are invalidated too aggressively or TTLs are too short. Check the hit rate in Query Monitor and verify that volatile groups are excluded rather than frequently flushed.