Tutorial: Finding a Slow meta_query and Rewriting It as a Taxonomy Filter
Three meta_query clauses become three INNER JOINs on a table with no index on the column being compared. Measuring that, then moving the filter into a taxonomy, takes an afternoon and turns a second into a dozen milliseconds.
