Changeset 11516 for trunk/src/bp-activity/classes/class-bp-activity-activity.php

Timestamp:

03/21/2017 01:35:23 AM (8 years ago)

Author:

boonebgorges

Message:

Remove unnecessary USE INDEX clause building in BP_Activity_Activity.

The resulting clause was unused since [8071].

Props vishalkakadiya.
Fixes #7460.

File:

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

trunk/src/bp-activity/classes/class-bp-activity-activity.php

@@ -545 +545 @@
         $join_sql = apply_filters( 'bp_activity_get_join_sql', $join_sql, $r, $select_sql, $from_sql, $where_sql );
 
-        /**
-         * Filters the preferred order of indexes for activity item.
-         *
-         * @since 1.6.0
-         *
-         * @param array $value Array of indexes in preferred order.
-         */
-        $indexes = apply_filters( 'bp_activity_preferred_index_order', array( 'user_id', 'item_id', 'secondary_item_id', 'date_recorded', 'component', 'type', 'hide_sitewide', 'is_spam' ) );
-
-        foreach( $indexes as $key => $index ) {
-            if ( false !== strpos( $where_sql, $index ) ) {
-                $the_index = $index;
-                break; // Take the first one we find.
-            }
-        }
-
-        if ( !empty( $the_index ) ) {
-            $index_hint_sql = "USE INDEX ({$the_index})";
-        } else {
-            $index_hint_sql = '';
-        }
-
         // Sanitize page and per_page parameters.
         $page     = absint( $r['page']     );