[buddypress-trac] [BuddyPress] #4041: Use SELECT FOUND_ROWS() for 'total' queries instead of a second query

[buddypress-trac at lists.automattic.com]

#4041: Use SELECT FOUND_ROWS() for 'total' queries instead of a second query
----------------------------+-----------------------------
 Reporter:  boonebgorges    |       Owner:  DJPaul
     Type:  defect (bug)    |      Status:  assigned
 Priority:  normal          |   Milestone:  Future Release
Component:  All Components  |     Version:
 Severity:  normal          |  Resolution:
 Keywords:                  |
----------------------------+-----------------------------
Changes (by boonebgorges):

 * milestone:  1.6 => Future Release


Comment:

 Thanks, cnorris23. I had seen that ticket but had not put two and two
 together as regards this one.

 I've done a bit of testing on my own setups with massive data sets and
 have found results similar to what webraket has suggested.

 In light of this, I want to put this off until the next dev cycle, at
 which point we can revisit and see if there's something from WP's
 (finished) version that we can riff off of in our own queries.

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