Changeset 6219 for trunk/src/includes/users/functions.php

Timestamp:

01/12/2017 08:46:10 AM (9 years ago)

Author:

johnjamesjacoby

Message:

Queries: Use no_found_rows where relevant.

This prevents SQL_CALC_FOUND_ROWS usages in places where it is not used.

Fixes #2972.

File:

• trunk/src/includes/users/functions.php (modified) (3 diffs)

trunk/src/includes/users/functions.php

@@ -323 +323 @@
     $user_id   = bbp_get_user_id( $user_id );
     $favorites = new WP_Query( array(
-        'fields'     => 'ids',
-        'post_type'  => bbp_get_topic_post_type(),
-        'nopaging'   => true,
-        'meta_query' => array( array(
+        'fields'        => 'ids',
+        'post_type'     => bbp_get_topic_post_type(),
+        'nopaging'      => true,
+        'no_found_rows' => true,
+        'meta_query'    => array( array(
             'key'     => '_bbp_favorite',
             'value'   => $user_id,
@@ -677 +678 @@
     $user_id       = bbp_get_user_id( $user_id );
     $subscriptions = new WP_Query( array(
-        'fields'     => 'ids',
-        'post_type'  => bbp_get_forum_post_type(),
-        'nopaging'   => true,
-        'meta_query' => array( array(
+        'fields'        => 'ids',
+        'post_type'     => bbp_get_forum_post_type(),
+        'nopaging'      => true,
+        'no_found_rows' => true,
+        'meta_query'    => array( array(
             'key'     => '_bbp_subscription',
             'value'   => $user_id,
@@ -705 +707 @@
     $user_id       = bbp_get_user_id( $user_id );
     $subscriptions = new WP_Query( array(
-        'fields'     => 'ids',
-        'post_type'  => bbp_get_topic_post_type(),
-        'nopaging'   => true,
+        'fields'        => 'ids',
+        'post_type'     => bbp_get_topic_post_type(),
+        'nopaging'      => true,
+        'no_found_rows' => true,
         'meta_query' => array( array(
             'key'     => '_bbp_subscription',