[buddypress-trac] [BuddyPress Trac] #8688: BP_Groups_Group::get_total_member_count() is highly inefficient, and runs out of memory

[buddypress-trac]

#8688: BP_Groups_Group::get_total_member_count() is highly inefficient, and runs
out of memory
--------------------------+---------------------
 Reporter:  dd32          |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  high          |   Milestone:  10.3.0
Component:  Groups        |     Version:  10.0.0
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |
--------------------------+---------------------

Comment (by imath):

 [https://buddypress.trac.wordpress.org/attachment/ticket/8688/8688.patch
 8688.patch] is my attempt to address Boone's concerns in #7614 and try to
 optimise the group members count query.

 - We need to validate group members are existing into `$wpdb->users`.
 - We need to make sure group members are active users (validated their
 account and logged once).

 @dd32 if it's possible for you to test the patch to see if it's better on
 profiles.w.org, that would be cool.

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