Defect #14906

Excessive queries on roles table when show a Issue

Added by Maicon Zucco about 5 years ago. Updated about 3 years ago.

Status:ResolvedStart date:
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Resolution: Affected version:2.3.2



Monitoring the Redmine MySQL queries from Redmine app I found a lot of queries on table roles.
For each member in project is executed a query below (changed the member_id) when I access the page "redmine/issues/xxxx":

SELECT `roles`.* FROM `roles` INNER JOIN `member_roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `member_roles`.`member_id` = 2310

The problem is that there are about 500 members in the issue project.

It’s possible to otimize this process?


Related issues

Related to Redmine - Defect #17700: Excessive DB querying when Allow Group Issue Assignment i... New


#1 Updated by Maicon Zucco almost 5 years ago

  • Status changed from New to Resolved


I found the "problem". I have selected the option "Allow issue assignment to groups".
After unselected this, the excessive queries was finished.


#2 Updated by Jan Niggemann ( team member) about 4 years ago

  • Related to Defect #17700: Excessive DB querying when Allow Group Issue Assignment is enabled added

#3 Updated by Javi Ferrer about 3 years ago

This problem also occurs when you have a custom field with user format.

Also available in: Atom PDF