Actions
Defect #14906
openExcessive queries on roles table when show a Issue
Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Affected version:
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
Actions