Changeset 3659

Timestamp:

01/04/2011 10:54:44 PM (16 years ago)

Author:

djpaul

Message:

Improve speed of forums' total topic count by alot. Fixes #2421

File:

• trunk/bp-forums.php (modified) (1 diff)

trunk/bp-forums.php

@@ -369 +369 @@
 
 function bp_forums_total_topic_count() {
-        do_action( 'bbpress_init' );
-
-        $query = new BB_Query( 'topic', array( 'page' => 1, 'per_page' => -1, 'count' => true ) );
-        $count = $query->count;
-        $query = null;
-
-        return $count;
+        global $bbdb;
+
+        do_action( 'bbpress_init' );
+
+        $count = $bbdb->get_results( $bbdb->prepare( "SELECT t.topic_id FROM {$bbdb->topics} AS t". groups_add_forum_tables_sql( '' ) . " WHERE " . groups_add_forum_where_sql( "t.topic_status = '0'" ) ) );
+        return apply_filters( 'bp_forums_total_topic_count', count( (array)$count ) );
 }