[buddypress-trac] [BuddyPress] #4045: Activity Feed queries fail with millions of rows

[buddypress-trac at lists.automattic.com]

#4045: Activity Feed queries fail with millions of rows
-----------------------------------+-----------------------------
 Reporter:  zacechola              |       Owner:
     Type:  defect (bug)           |      Status:  new
 Priority:  normal                 |   Milestone:  Future Release
Component:  Activity               |     Version:  1.5.4
 Severity:  normal                 |  Resolution:
 Keywords:  2nd-opinion has-patch  |
-----------------------------------+-----------------------------
Changes (by boonebgorges):

 * milestone:  1.6 => Future Release


Comment:

 I think we've done all that we can do for this dev cycle.

 During the next one, I want to have a look at the possibility of splitting
 the query. I recently learned that MySQL can't create temp tables in RAM
 if the temp table includes fulltext. So we might think about doing a
 `SELECT id` lookup before getting the content of the activity items
 themselves. But this will break (some) legacy filters of the SQL
 statement, so we'll wait for 1.7.

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