Skip to:
Content

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


Ignore:
Timestamp:
04/11/2017 06:22:00 PM (14 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.