Changeset 9482 for trunk/src/bp-messages/bp-messages-classes.php

Timestamp:

02/13/2015 05:24:33 PM (11 years ago)

Author:

boonebgorges

Message:

Cache the results of BP_Messages_Thread::get_recipients().

This can save a large number of queries on certain inbox views.

Props wpdennis.
See #6221. Fixes #6220.

File:

• trunk/src/bp-messages/bp-messages-classes.php (modified) (1 diff)

trunk/src/bp-messages/bp-messages-classes.php

@@ -214 +214 @@
                 global $wpdb;
 
-                $bp = buddypress();
-
-                $recipients = array();
-                $results    = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$bp->messages->table_name_recipients} WHERE thread_id = %d", $this->thread_id ) );
-
-                foreach ( (array) $results as $recipient ) {
-                        $recipients[$recipient->user_id] = $recipient;
+                $recipients = wp_cache_get( 'thread_recipients_' . $this->thread_id, 'bp_messages' );
+                if ( false === $recipients ) {
+                        $bp = buddypress();
+
+                        $recipients = array();
+                        $results    = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$bp->messages->table_name_recipients} WHERE thread_id = %d", $this->thread_id ) );
+
+                        foreach ( (array) $results as $recipient ) {
+                                $recipients[ $recipient->user_id ] = $recipient;
+                        }
+
+                        wp_cache_set( 'thread_recipients_' . $this->thread_id, $recipients, 'bp_messages' );
                 }