Defect #14906

Excessive queries on roles table when show a Issue

Added by Maicon Zucco about 4 years ago. Updated about 2 years ago.

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

0%

Category:Issues
Target version:-
Resolution: Affected version:2.3.2

Description

Hi,

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?

Thanks.


Related issues

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

History

#1 Updated by Maicon Zucco about 4 years ago

  • Status changed from New to Resolved

Hi,

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

Thanks.

#2 Updated by Jan Niggemann (redmine.org team member) about 3 years ago

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

#3 Updated by Javi Ferrer about 2 years ago

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

Also available in: Atom PDF