Defect #17203
open
Redmine is slow to create new issues or edit users that belongs to a big number of projects.
0%
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" = 280xxIs it possible to speed up this queries?
Thanks.
Updated by Etienne Massip over 10 years ago
I think there has been some speed enhancement work done on this specific query, maybe you should test with latest version.
Updated by Anonymous over 10 years ago
Not proposing this as a solution, rather just a general suggestion: check your server log file size..
Recently I noticed a number of areas in my application were getting slower and slower, especially with issue creation and updating. After restarting with a clean log file (it was close to 500k lines / 60MB at that point) suddenly the whole interface was back to being as snappy as it was when we first started with it. With the number of projects you have in your system (compared to my 50-odd), perhaps this would make a bigger difference to you.
The wiki has some info on setting up a log file rotation system to keep the running log file size down, but I haven't yet managed to get that working in my Bitnami stack based system.