Is ‘no_found_rows’ a silver bullet for WP_Query optimization when getting all posts of a certain type?
I’m running a query (200-300 posts), while this might not be for a lot of people / hosts, I just want to optimize wherever I can, given the fact that a lot of things happen when running that particular script, and so, my motivation is optimization.
My query is exactly:
$args = [ 'post_type' => 'post', 'orderby' => 'ASC', 'post__in' => $post_ids ]; $headers = new WP_Query( $args );
So I’m asking the database to just give me everything that matches these IDs. But I don’t need any meta information, no paging information, no counting of the posts, nothing, just the raw posts, so I was thinking of adding
no_found_rows => true to the query.
While this clearly speeds things up, if I think of all the
WP_Query I wrote through my system, I rarely need to know pagination or their count.
Or don’t I? When there’s no pagination, how does the system know to go to the next “batch”?
In other, simpler words: is
no_found_rows => true a must-have when querying big lists of posts where you just need to know about all the posts in a given query?