Defect #6019

Extremely slow SVN update

Added by Polar Bear about 7 years ago. Updated about 7 years ago.

Status:ClosedStart date:2010-08-03
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:SCM
Target version:-
Resolution: Affected version:

Description

As you can see here http://dev.getyhm.com/projects/yhm/repository
My repository is loading extremely slow for each page and it's killing me.
Any ideas why this is happening?

I am running it off a remote SVN but surely it can't take that long just to load a page?

History

#1 Updated by Go MAEDA about 7 years ago

Please try the patch that I submitted at #6159.

The patch makes Redmine's repository browser faster by reducing exection of "svn log" command.

#2 Updated by Polar Bear about 7 years ago

Only slightly.

Before: Completed in 9976ms (View: 279, DB: 133) | 200 OK
After Change: Completed in 9455ms (View: 108, DB: 23) | 200 OK

#3 Updated by Tiago Queirós about 7 years ago

Polar Bear wrote:

Only slightly.

Before: Completed in 9976ms (View: 279, DB: 133) | 200 OK
After Change: Completed in 9455ms (View: 108, DB: 23) | 200 OK

I got this worse...

Rendering repositories/show
Completed in 155493ms (View: 121, DB: 9)

New project, couple hundred files. Some binary in it.
8(!) commits so far.

redmine 1.0.1.stable
MySQL (local)
subversion (local)
ruby 1.8.7
rails 2.3.5

How can I debug this?

#4 Updated by Felix Schäfer about 7 years ago

How long does svn ls <the address you entered in redmine> take on the host redmine is hosted on?

#5 Updated by Felix Schäfer about 7 years ago

How long does svn ls <the address you entered in redmine> take on the host redmine is hosted on?

#6 Updated by Tiago Queirós about 7 years ago

Felix Schäfer wrote:

How long does svn ls <the address you entered in redmine> take on the host redmine is hosted on?

~# time svn ls http://<local ip>/svn/<repo>
(...)
real    0m0.663s
user    0m0.052s
sys    0m0.007s

Where real varies somewhat.

#7 Updated by Polar Bear about 7 years ago

real 0m2.475s
user 0m0.008s
sys 0m0.005s

#8 Updated by Felix Schäfer about 7 years ago

  • Status changed from New to Closed

Polar Bear wrote:

real 0m2.475s
user 0m0.008s
sys 0m0.005s

This is it then. Most (if not all) pages on the repository view make accesses to the svn repository, and if each takes 2 seconds at least, that makes your page load very slow.

You could minimize the impact of this by e.g. fetching the commits from your svn repository through cron or post-commit hook, see FAQ, and disable auto-fetching in the global config.

Also available in: Atom PDF