[buddypress-trac] [BuddyPress Trac] #5341: Avoid bloat in the activity table when recording blog post activity items

[buddypress-trac]

#5341: Avoid bloat in the activity table when recording blog post activity items
--------------------------+----------------------
 Reporter:  henry.wright  |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Core          |     Version:
 Severity:  normal        |  Resolution:  wontfix
 Keywords:                |
--------------------------+----------------------
Changes (by boonebgorges):

 * status:  new => closed
 * resolution:   => wontfix
 * milestone:  Awaiting Review =>


Comment:

 The biggest issue here is that, on a multisite setup, the posts come from
 all over the network. Thus, you'd need to `switch_to_blog()` for every
 post. This would create a huge amount of overhead on every pageload. Even
 on a non-multisite setup, loading 20 blog posts is much more resource-
 intensive than doing the single SQL query that the activity stream
 currently requires.

 You might think of the excerpt stored in the activity table as a sort of
 cache: a readily accessible copy of the original data, optimized for quick
 access.

 Thanks for the thought!

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