Project

General

Profile

Actions
Copy link

Defect #17203

open

Redmine is slow to create new issues or edit users that belongs to a big number of projects.

Added by Alexis Romagnoli almost 10 years ago. Updated over 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:
2.4.2

Description

Hi,

I'm having speed problems with an installation of Redmine 2.4.2.stable, that has about 2000 projects.
When I try to create an issue or edit a user that belongs to all these projects, the page takes to load
about 18 seconds.

When I click on the user, on the Administration page, in the production.log file I find 2000 lines like this one:

MemberRole Load (0.3ms)  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" = 280xx

Is it possible to speed up this queries?

Thanks.

Actions
Copy link

Also available in: Atom PDF