poocommerce-performance

name	poocommerce-performance
description	Identify performance issues in PooCommerce PHP code. Use when writing or reviewing code that loads collections of post-based objects (products, orders), renders product lists with images, reads multiple options in a loop or method, or writes SQL queries involving joins, aggregates, meta lookups, or range queries.

PooCommerce 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 PooCommerce 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, PooCommerce lookup table preference (wc_product_meta_lookup, wc_product_attributes_lookup), and MIN/MAX full-scan elimination.