[buddypress-trac] [BuddyPress Trac] #8591: Improve query that runs to find total activities count in spam activity table

[buddypress-trac]

#8591: Improve query that runs to find total activities count in spam activity
table
-------------------------+---------------------
 Reporter:  oztaser      |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  10.0.0
Component:  Activity     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |
-------------------------+---------------------

Comment (by imath):

 Hi @oztaser

 I gave a deeper look to this issue. Even if you set the `per_page`
 attribute to 1, there's an extra query that is run.

 In 8591.2.patch, I'm suggesting to introduce a new argument to
 `BP_Activity_Activity::get()` so that it's possible to only get the result
 of a count query. Could you check it's improving your situation?

 Thanks in advance.

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