[buddypress-trac] [BuddyPress] #4018: @mentions (slow query)

[buddypress-trac at lists.automattic.com]

#4018: @mentions (slow query)
-------------------------------------+-----------------------------
 Reporter:  webraket                 |       Owner:
     Type:  enhancement              |      Status:  new
 Priority:  normal                   |   Milestone:  Future Release
Component:  Activity                 |     Version:  1.5.3
 Severity:  major                    |  Resolution:
 Keywords:  has-patch needs-testing  |
-------------------------------------+-----------------------------
Changes (by boonebgorges):

 * milestone:  1.6 => Future Release


Comment:

 After having done a lot of research into the subject #4045, I think that
 the @mention problem will probably not be solvable without doing something
 like webraket suggests:

 > I think we should add (indexed)keys to activity_meta:
 > mentioned_user_123
 > mentioned_group_456

 That is to say, there's no amount of query optimization we could do to
 `BP_Activity_Activity::get()` that would speed up `LIKE '%%foo%%'` style
 queries on huge varchar columns. Adding an index is not really an option
 for BP core, as it will slow down the write process enormously (though
 it's fine to do on individual sites if it's helpful).

 So yes, let's punt.

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