[buddypress-trac] [BuddyPress Trac] #7614: Group member count routine is bad

[buddypress-trac]

#7614: Group member count routine is bad
--------------------------+-----------------------
 Reporter:  boonebgorges  |       Owner:  imath
     Type:  enhancement   |      Status:  assigned
 Priority:  normal        |   Milestone:  11.0.0
Component:  Groups        |     Version:  1.2.3
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |
--------------------------+-----------------------

Comment (by dcavins):

 To a longer-term solution, I wonder if tracking those who have never
 logged in would be more efficient than tracking those who have logged in.
 On a well-maintained system, I'd hope that there were more real users than
 cruft. Can we ask the profiles team for example, to compare the total
 number of User IDs/signups to the result of the following query?

 {{{
 SELECT count(distinct `user_id`)
 FROM `wp_bp_activity`
 where `type` = 'last_activity'
 }}}

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