What is the WordPress Large Site optimization technique involving `’no_found_rows’ => true` in WP_Query and when must it NOT be used?

Question

WordPress Expert — Hard

What is the WordPress Large Site optimization technique involving `’no_found_rows’ => true` in WP_Query and when must it NOT be used?

Accepted Answer

Using `no_found_rows => true` in a WP_Query removes the SQL_CALC_FOUND_ROWS directive, improving query performance. However, it should not be used when pagination is required to avoid breaking pagination links.