Project

General

Profile

Rendering of projects/index is too slow.

Added by Nikolay Gassyuk over 11 years ago

Our Redmine works very slow. What the reason and what I have to do to improve this situation? Help me to solve this problem please.

Software:

Redmine 1.2.1
Ruby1.8
Rails 2.3.5
MySQL 5.1.49

Hardware:VPS
total used free
Mem: 2000 741 1259

CPU:
model name : Intel(R) Xeon(R) CPU X5650 @ 2.67GHz
stepping : 2
cpu MHz : 984.445
cache size : 12288 KB

CPU usage ~12%

The most slow is Rendering projects/index:

Processing ProjectsController#index (2012-09-14 13:22:49) [GET]
  Parameters: {"action"=>"index", "controller"=>"projects"}
Rendering template within layouts/base
Rendering projects/index
Completed in 21477ms (View: 21464, DB: 1) | 200 OK [http://redmine.domain/projects]

I tried to use mongrel:

/usr/bin/mongrel_rails start -e production  -p 49640 -a 127.0.0.1 -n 1  -c /opt/redmine/redmine-1.2.1/

It helps a little bit, Rendering projects/index is about 14000ms, but it very slow.

production.log (70.2 KB) production.log production.log

Replies (3)

RE: Rendering of projects/index is too slow. - Added by Jan Niggemann (redmine.org team member) over 11 years ago

Do you have plugins installed and if so, which?

RE: Rendering of projects/index is too slow. - Added by Nikolay Gassyuk over 11 years ago

The reason is "Project filtering plugin" and now rendering of the project list page is about 4-7 seconds.

But anyway it is very slow for such server resources. How to make redmine work faster?

Installed plugins:

redmine_contacts
redmine_extra_query_operators
redmine_lightbox
redmine_project_filtering
redmine_spent_time_required
redmine_time_tracker
redmine_uploads
redmine_xls_export

We have about 200 projects and about 3500 issues.

RE: Rendering of projects/index is too slow. - Added by Jan Niggemann (redmine.org team member) over 11 years ago

It's neither the projects / issues count, nor the servers' resources. A while ago there was a thread here about performance and server resources and yours should be sufficient.

    (1-3/3)