I have a ton of posts that I need to get the IDs of based on a custom taxonomy search. As it's used for pagination, I also need to get the total posts without a limit, but I'm not sure how. I use the following get_posts to find them:
$args = array('posts_per_page' => $limit, 'offset' => $offset, 'category' => '1', 'orderby' => 'post_date', 'order' => 'DESC', 'post_type' => 'attachment', 'post_status' => 'inherit', 'suppress_filters' => true, 'tax_query' => $search_terms, // Fairly complex search array ); $attachments = get_posts($args);
But the trouble comes when I want to build a paging system based off of these results - I need to get the total posts without the limit in place. I could do the same search again and exclude $limit, but due to the sheer number of posts (300k+) it's extremely slow especially when I only need the total number of posts and not all their information. Even get_posts seems a bit too heavy for something as simple as just getting attachment IDs.
I tried building a good old fashion MySQL query to handle it, but handling taxonomies is done so much cleaner with the above method and I couldn't seem to get it working right.
Any advice would be greatly appreciated! Thank you!