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

[buddypress-trac]

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

 * keywords:  2nd-opinion => has-patch
 * type:  defect (bug) => enhancement


Comment:

 `02.patch` adds an upgrade routine to drop the `hide_sitewide` and
 `is_spam` indexes and upgrades the activity DB table to add the new,
 proposed index.

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