Changeset 3660 for trunk/bp-groups/bp-groups-filters.php

Timestamp:

01/05/2011 10:03:41 PM (14 years ago)

Author:

djpaul

Message:

Speed up forum directory's "last active" bbPress SQL query to stop it fetching information we aren't using. Helps fix #2421

File:

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

trunk/bp-groups/bp-groups-filters.php

@@ -106 +106 @@
 add_filter( 'bb_current_user_can', 'groups_filter_bbpress_caps', 10, 3 );
 
+/**
+ * Amends the forum directory's "last active" bbPress SQL query to stop it fetching
+ * information we aren't going to use. This speeds up the query.
+ *
+ * @see BB_Query::_filter_sql()
+ * @since 1.3
+ */
+function groups_filter_forums_root_page_sql( $sql ) {
+    return apply_filters( 'groups_filter_bbpress_root_page_sql', 't.topic_id' );
+}
+add_filter( 'get_latest_topics_fields', 'groups_filter_forums_root_page_sql' );
 ?>