[buddypress-trac] [BuddyPress Trac] #7500: Harmful bp_activity indexes

[buddypress-trac]

#7500: Harmful bp_activity indexes
--------------------------+----------------------------------
 Reporter:  brandonliles  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Under Consideration
Component:  Performance   |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  2nd-opinion   |
--------------------------+----------------------------------
Changes (by r-a-y):

 * component:  Core => Performance
 * milestone:  Awaiting Review => Under Consideration


Comment:

 @brandonliles - So is `01.patch` what you are recommending?  Or did you
 keep the existing indexes on `hide_sitewide` and `is_spam` intact?

 My SQL-fu is not that great, so I'll leave it to you guys to discuss.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7500#comment:7>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac