Skip to:
Content

Changes between Initial Version and Version 1 of Ticket #7442, comment 4


Ignore:
Timestamp:
04/11/17 18:22:00 (9 months ago)
Author:
brandonliles
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #7442, comment 4

    initial v1  
    11After seeing the query still perform poorly on a site I took another look, although joins can improve performance, MySQL still tends to look at too many rows in the bp_activity table. Determining the matching user_ids first and plugging those values into the query is a major performance improvement. 
     2 
     3New patch bp-search-optimize.patch added.