Project

General

Profile

Actions

Defect #10992

open

Issue details page loads slowly with lots of watchers

Added by Duane Hughes almost 12 years ago. Updated almost 12 years ago.

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

0%

Estimated time:
Resolution:
Affected version:

Description

Hi,

I'm currently testing a redmine implementation for our company's issue reporting needs. We have a lot of users at our company who are permitted to submit problem reports (They authenticate via LDAP). I've added them to the Reporters group for our redmine project. This means that they show up as watchers if you click "New Issue", or i presume get loaded in the background if you open an existing issue. We have 820 users currently. On our 4-core processor system with 4096MB RAM, the "New Issues" page takes about 7 seconds to load. I enabled INFO logging for our production environment and the numbers are as follows:

Processing IssuesController#new (for x.x.x.x at 2012-05-22 15:27:56) [GET]
  Parameters: {"controller"=>"issues", "project_id"=>"support", "action"=>"new"}
Rendering template within layouts/base
Rendering issues/new
Completed in 4942ms (View: 4668, DB: 140) | 200 OK [http://servername/support/projects/support/issues/new]

As can be seen, it takes 4668ms just to render the page, although the DB lookup is fast enough.

I'm running Redmine 1.4.2 on Apache2 (2.2.22) with libapache2-mod-passenger (2.2.11) on Ubuntu 12.04. Database runs on mysql 5.5.22.

My environment is as follows:

Ruby version              1.8.7 (x86_64-linux)
RubyGems version          1.8.15
Rack version              1.1.3
Rails version             2.3.14
Active Record version     2.3.14
Active Resource version   2.3.14
Action Mailer version     2.3.14
Active Support version    2.3.14
Application root          /usr/share/redmine
Environment               production
Database adapter          mysql
Database schema version   20120301153455

I've also removed all the plugins I added to eliminate any of them as the possible source of the problem, and the numbers above are generated after doing that.

Could you provide any suggestions for optimizing performance to circumvent this problem? Or could this be an issue with how the list of watchers or the page is rendered or called in the background? Could the watchers list be called in some other way to prevent it being loaded until actually required (instead of rendering all 820 watchers checkboxes?) Needless to say, as soon as I remove the 820 users as members of our project, the Issues detail and New Issues page load lightning fast.

FWIW, I've tried this on a lighttpd server with mod_fastcgi, and the page loads slightly faster at 5 seconds (shaves 2 seconds off the loading time), but this remains an issue.

Any help would be appreciated. Thanks!


Files

removes_watcher_checkboxes.patch (581 Bytes) removes_watcher_checkboxes.patch Jean-Philippe Lang, 2012-05-24 19:10
Actions

Also available in: Atom PDF