Changes between Initial Version and Version 1 of Ticket #7442, comment 4
- Timestamp:
- 04/11/2017 06:22:00 PM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #7442, comment 4
initial v1 1 1 After 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 3 New patch bp-search-optimize.patch added.