Project

General

Profile

Actions

Defect #6019

closed

Extremely slow SVN update

Added by Polar Bear over 13 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
SCM
Target version:
-
Start date:
2010-08-03
Due date:
% Done:

0%

Estimated time:
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?

Actions #1

Updated by Go MAEDA over 13 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.

Actions #2

Updated by Polar Bear over 13 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

Actions #3

Updated by Tiago Queirós over 13 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?

Actions #4

Updated by Felix Schäfer over 13 years ago

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

Actions #5

Updated by Felix Schäfer over 13 years ago

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

Actions #6

Updated by Tiago Queirós over 13 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.
Actions #7

Updated by Polar Bear over 13 years ago

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

Actions #8

Updated by Felix Schäfer over 13 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.

Actions

Also available in: Atom PDF