Painfully slow?

Added by Rafi Greenberg over 9 years ago

So I upgraded to Redmine 2.0.2, and pages are loading extremely slowly. Here's our config:

Redmine version 2.0.2.stable
Ruby version 1.8.7 (x86_64-linux)
Rails version 3.2.5
Environment production
Database adapter MySQL
Redmine plugins:
redmine_dmsf 1.4.0 devel
redmine_inline_attach_screenshot 0.3.2
redmine_lightbox 0.0.1

Here is a snippet from the logs for just viewing an issue:

Started GET "/redmine/issues/1553" for x.x.x.x at Wed Jun 06 18:02:56 -0700 2012
Processing by IssuesController#show as HTML
Parameters: {"id"=>"1553"}
Rendered issues/_action_menu.html.erb (14.0ms)
Rendered issue_relations/_form.html.erb (4.1ms)
Rendered issues/_relations.html.erb (8.0ms)
Rendered issues/_action_menu.html.erb (11.5ms)
Rendered issues/_form_custom_fields.html.erb (0.3ms)
Rendered issues/_attributes.html.erb (600.3ms)
Rendered issues/_form.html.erb (660.1ms)
Rendered plugins/redmine_inline_attach_screenshot/app/views/attachments/_form.html.erb (15.6ms)
Rendered issues/_edit.html.erb (705.0ms)
Rendered issues/_sidebar.html.erb (485.2ms)
Rendered watchers/_watchers.html.erb (37.7ms)
Rendered issues/show.html.erb within layouts/base (1315.4ms)
Completed 200 OK in 2501ms (Views: 403.4ms | ActiveRecord: 1959.6ms)

2.5 seconds just to view an issue? Redmine 1.x was significantly faster. Any ideas why the upgrade to Rails 3 made such a difference in load times?

Thanks for your help.

Replies (2)

RE: Painfully slow? - Added by A. G. about 9 years ago

Did you manage to improve performance eventually?

I am facing the same issue under same ruby/rails config.

Upgrading to ruby1.9.3 and changing mysql adapter to mysql2 fixes ActiveRecord performance problem, so your "ActiveRecord: 1959.6ms" may become "ActiveRecord: 59.6ms".
But page View rendering is still painfully slow.

Completed 200 OK in 3065ms (Views: 2896.6ms | ActiveRecord: 28.0ms)

Based on this it appears that Rails-3.2/Ruby-1.8.7 is the worst possible combination. But even with Ruby1.9.3-p327 things are not that much better on a reasonable powerful hardware.

RE: Painfully slow? - Added by Christof Graf almost 9 years ago

Any update on the situation ?

Rendering an issue with 4 related tasks is really slow:

Rendered issues/show.html.erb within layouts/base (5570.1ms)
Completed 200 OK in 5695ms (Views: 4825.4ms | ActiveRecord: 854.4ms)

My env:

 Redmine version                          2.2.2.stable.11352
  Ruby version                             1.9.3p385 (x86_64-linux)
  Rails version                            3.2.11
  Environment                              production
  Database adapter                         Mysql2
Redmine plugins:
  redmine_backlogs                         v0.9.35