How to get Total Post In a Selceted category

March 1, 20232 Views

i have a wordpress site that has around 20000 post
it gets slow at generating pagination. i have traced the problem.

$my_query = new WP_Query($query_string ."&posts_per_page=-1");
$total_posts = $my_query->post_count;

is there any other faster way to get total post on a selected category.

Post Views: 2

3 comments

Anonymous says:

March 1, 2023 at 2:58 am
I have one solution for you.
This code will show and unordered list with the name of the category and the count of posts containded in it.
```
<ul class="myClass">
 <?php $categories = get_categories('number=100');
       foreach ($categories as $cat) {
       echo "<li>". $cat->cat_name . " Total posts: ". $cat->category_count ."</li>";
       } ?>
</ul>
```
Retrieves the 100 first categories
```
$categories = get_categories('number=100');
```
and for each of them shows cat_name and category_count

Well the result I presume you really need can now be handled in a var by $cat->category_count, i.e:
```
$total_num_posts_in_your_category = $cat->category_count
```
I hope that could help you.
Log in to Reply
Anonymous says:

March 1, 2023 at 2:59 am

It seems there isn’t one. The default WordPress count function does not support category posts count:

http://codex.wordpress.org/Function_Reference/wp_count_posts

Log in to Reply

you can use get_category :

 $thisCat = get_category(get_query_var('cat'),false);
$total_posts = $thisCat->count;