WooCommerce Performance

Post Cache Priming — cache-priming.md

Use when writing or reviewing code that loads collections of post-based objects (products, orders) or renders product lists with images. Covers _prime_post_caches() usage patterns — both as a generation guide (apply these patterns when writing new code) and a review guide (flag missing priming in existing code).

Options Cache Priming — options-cache-priming.md

Use when writing or reviewing code that reads multiple non-autoloaded options in a loop or method. Covers wp_prime_option_caches() usage patterns for static key lists, derivable key patterns, and dynamically extracted key sets (excluding autoloaded options, which are already in cache).

SQL Query Patterns — sql-query-patterns.md

Use when writing or reviewing any SQL query in WooCommerce PHP code. Covers: redundant posts joins, fan-out JOIN on wp_term_relationships, N-query loops, OR index-merge, cross-product meta conditions, multi-fan join decoupling, WooCommerce lookup table preference (wc_product_meta_lookup, wc_product_attributes_lookup), and MIN/MAX full-scan elimination.