[buddypress-trac] [BuddyPress Trac] #5448: Remove SQL Hints from Activities class

[buddypress-trac]

#5448: Remove SQL Hints from Activities class
-------------------------+-----------------------------
 Reporter:  zippykid     |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Core         |    Version:  1.9.2
 Severity:  normal       |   Keywords:
-------------------------+-----------------------------
 This ticket is the result of a discussion here:
 http://buddypress.org/support/topic/performance-issues-with-the-
 wp_bp_activities-table/

 Basically, I think it would be good if the SQL hint should be removed from
 the query in the activities class that returns a COUNT() .

 Some tests and results of EXPLAIN are provided here;
 https://gist.github.com/vidluther/9370018

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5448>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac