[buddypress-trac] [BuddyPress] #3497: Faster function for get activity

[buddypress-trac]

#3497: Faster function for get activity
-----------------------------------+-----------------------------
 Reporter:  finzend                |       Owner:
     Type:  enhancement            |      Status:  new
 Priority:  normal                 |   Milestone:  Future Release
Component:  Activity               |     Version:
 Severity:  normal                 |  Resolution:
 Keywords:  has-patch 2nd-opinion  |
-----------------------------------+-----------------------------

Comment (by finzend):

 You guys do great work for Buddypress and we love to use it, but why is
 this still not adjusted? This weekend I installed version 1.9.1 and the
 performance was dramatic. Some pages took 10 seconds or more to load.. I
 updated bp_activity_classes with my own adjustements from previous time.
 The result: the queries where more than 6 times faster (again) and
 everything loaded smoothly.

 We have around 1 million records in wp_bp_activity, but the new code is
 also much quicker with less records.

 I really think this code should be included in a new version (asap). I
 will add my php-file to this thread (code changes are commented with
 "finzend").

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/3497#comment:6>
BuddyPress <http://buddypress.org/>
BuddyPress