Actions
Feature #44382
open
Reduce the number of SQL queries when filtering issues by "Assignee's group" or "Author's group"
Status:
New
Priority:
Normal
Assignee:
-
Category:
Performance
Target version:
-
Resolution:
Description
When filtering issues by "Assignee's group" or "Author's group", IssueQuery fetches the members of each group with a separate SQL query.
With the "any" or "none" operators, all groups are iterated, so the number of queries grows with the number of groups in the Redmine instance. For example, building the filter condition on a system with 100 groups executes 100 queries.
The attached patch fetches the members of all groups with a single query, using the same subquery style as the existing User.in_group scope. The generated where clause is unchanged.
Files
No data to display
Actions