Can I count matches without doing a query?

Question

I'm trying to count results for a given query, but I don't actually need the posts so I'm trying to figure out if there's a way to count posts without querying them. Something similar to https://codex.wordpress.org/Function_Reference/wp_count_posts

I'm counting posts by meta key/value so wp_count_posts() won't work.

Here's what I'm currently doing:

$query = new WP_Query(array(
  "post_type" => 'my-post-type',
  "posts_per_page" => 0,
  "meta_key" => "my_custom_key",
  "meta_value" => "some_value",
));

echo $query->found_posts;

Answer 1

The non perfect solution is to just minimize the amount of information carried by the query, and the side effects. This can be done by requesting only the post IDs and not populating any caches.

Your query should be something like

$query = new WP_Query(array(
  ...
  'fields' => 'ids',
  'cache_results' => false,
  'update_post_meta_cache' => false,
  'update_post_term_cache' => false,
));

So you still get too much information - an array of integers instead of one, but since the DB has to go over them in any case the main overhead is probably the time to transfer it, and if you do not expect 1000s of posts matching your query, then it should be good enough.

The reason I would prefer this approach over trying to figure out all the required joins and write a proper SQL, is that it is much easier to read and modify than an SQL statement. Still requires a good comment about the why of it.

Answer 2

You set posts_per_page 0 value. posts_per_page for all posts set -1 or another positive number

$query = new WP_Query( array(
  "post_type"       => 'my-post-type',
  "posts_per_page"  => -1,
  "meta_key"        => "my_custom_key",
  "meta_value"      => "some_value",
) );

echo $query->found_posts;