[buddypress-trac] [BuddyPress] #2372: @mention in wordpress post comment
buddypress-trac
noreply at wordpress.org
Thu Nov 21 01:36:20 UTC 2013
#2372: @mention in wordpress post comment
-------------------------+-----------------------------
Reporter: intimez | Owner:
Type: enhancement | Status: reopened
Priority: normal | Milestone: Future Release
Component: Blogs | Version: 1.5
Severity: normal | Resolution:
Keywords: has-patch |
-------------------------+-----------------------------
Comment (by boonebgorges):
> Are @-mentions in blog posts and comments currently dependent on the
activity component being active?
Yes. @-mentions in general are dependent on the Activity component.
The problem with r-a-y's patch is not that it'll have any ill effects when
activity is *disabled* (in which case it'll in fact have no effect at
all), but instead when activity is *enabled*. We currently store only
short excerpts of blog posts in the 'content' column of the activity table
- only a few hundred characters - but storing the full text of blog posts
would mean that we're storing many, many times that. This will slow down
the activity table in a number of important ways. The key issue in this
case is that @-mention are fetched by a `LIKE` query, and the performance
of those kinds of queries will degrade at least linearly with the
increasing size of the haystack.
--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/2372#comment:11>
BuddyPress <http://buddypress.org/>
BuddyPress
More information about the buddypress-trac
mailing list