[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   |
--------------------------+----------------------------------

Comment (by brandonliles):

 @r-a-y 01.patch is exactly what I'm recommending. I didn't keep the
 existing indexes, due to their low selectivity they are more likely to
 cause the optimizer to use a poor query plan.

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