Resolve "MembersFinder contains slow database query with OR conditions"
What does this MR do?
Improve MembersFinder query performance by using
UNION instead of
OR where id IN
Does this MR meet the acceptance criteria?
- Changelog entry
- [-] Documentation created/updated or follow-up review issue created
- Code review guidelines
- Merge request performance guidelines
- Style guides
- Database guides
- Separation of EE specific content
Performance and testing
- [-] Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.
- [-] Tested in all supported browsers
Closes #64180 (closed)