Issue 77281 - svn: performance problem when during commit
Summary: svn: performance problem when during commit
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Infrastructure
Classification: Infrastructure
Component: _openoffice.org SVN (obsolete) (show other issues)
Version: current
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: Unknown
QA Contact: issues@www
URL:
Keywords:
Depends on:
Blocks: 2587
  Show dependency tree
 
Reported: 2007-05-12 17:04 UTC by Martin Hollmichel
Modified: 2009-07-12 18:27 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
sources used for initial add/commit (797.06 KB, application/x-gzip)
2007-05-22 14:46 UTC, Martin Hollmichel
no flags Details
script to add a new line to all files, and measure time for commit (1.24 KB, application/x-gzip)
2007-05-22 14:49 UTC, Martin Hollmichel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Martin Hollmichel 2007-05-12 17:04:14 UTC
There are two test scenarios: (1) add a new directory with 165 files (4.2 MB)
and commit them and (2) add a single line in one file and commit that file.

for CVS on the main site we have:

(1) 77 sec       (2) 4.8 sec

for svn on the main site we have (direct access without proxy):

(1) 198 sec      (2) 9.3 sec

for svn on the main site and using a proxy server we have

(1) 289 sec      (2) 9.4 sec
(this was measured during the weekend where the proxy is idle)
(1) n/a          (2) 14 sec
(measured during regular German business hours)

svn commit performance is at least factor 2 slower than cvs, I consider this as
a regression and a blocker for a transition to svn.

svn performance seem to be dependent from the load of the used proxy, do you
have advise about a recommended proxy set up ?
Comment 1 Unknown 2007-05-14 04:37:04 UTC
Hi,

Thank you for contacting CollabNet Customer Support. Based on the information
that has been provided to us, we will initiate our research & provide you an
update as soon as we have adequate information. 

Thanks,
Pritha
Support Operations.
Comment 2 Unknown 2007-05-17 11:11:58 UTC
I have few questions :

1) What is the proxy server setup been used for these testing .
2) Since the svn commit transaction use the same port as in the normal web
traffic.Please provide us information whether this testing was done in the
office network or home network . 
4)Also details on whether there is any restriction on the traffic allowed from
the office network/home network would be most useful in our investigation.


Comment 3 Unknown 2007-05-17 15:16:51 UTC
Updating whiteboard.
Comment 4 Martin Hollmichel 2007-05-18 08:31:46 UTC
>2) Since the svn commit transaction use the same port as in the normal web
>traffic.Please provide us information whether this testing was done in the
>office network or home network .
testing was done in office network (34 MBit line) and home office (2MBit DSL
line) ; the measurements done in both networks were almost identical.
  
>4)Also details on whether there is any restriction on the traffic allowed from
>the office network/home network would be most useful in our investigation.
both boxes used a natting firewall

Comment 5 Unknown 2007-05-18 16:16:49 UTC
Mh , 

In Theory for 'commit' itself svn may perform exceptionally well for certain
cases (svn commit of hugefile with small change).

Having said that Subversion has certain overheads like more HTTP connections
from the client to server to do one logical svn command. Spooling the data to
temporary area prior to sending the data to server(due to neon), Compressing the
data etc.

However we are still actively investigating on this and looking at various
options were we might consistently reproduce similar slowness in comparison to
the cvs commits . 
Comment 6 Unknown 2007-05-21 13:50:53 UTC
Given below is some testing perform by our engineers :

We tried adding 170 1MB (all 'a's in it) files for cvs and svn

Without -z9 compression :

CVS 
-------
real    1m38.753s
user    0m0.895s
sys     0m1.585s

SVN
-------
real    2m19.443s
user    0m16.768s
sys     0m3.868s

Later we perform testing taking into consideration the 'client compression'
factor as CVS by default has no compression unless invoked with -z9. However SVN
by default has zlib compression

With -z9 compression factor :

CVS 
---------------
real    2m39.754s
user    0m7.572s
sys     0m0.620s

SVN
---------------
real    1m5.367s
user    0m15.329s
sys     0m3.613s

This inconsistent result though the second one in favor of svn suggests that
'-z9' could be making a difference.

I assume these test were performed with the cvs -z9 compression factor.

Please note in theory subversion is faster for commits. In practice it may be
slow for some datasets/usage patterns. We need a solid repeatable case so that
we can at-least justify the behavior if not change it.

-Jobin.
Comment 7 Martin Hollmichel 2007-05-22 10:00:31 UTC
for the test with CVS we're using a ssh tunnel with CompressionLevel 3, the cvs
client itself is usually called without any compression switch (-z x).

you're right, if additionally starting the cvs client with high compression, the
times rise, but I think this is not relevant in this comparison.
Comment 8 gerd.weiss 2007-05-22 12:02:34 UTC
1) What is the proxy server setup been used for these testing

Squid Cache: Version 2.6.STABLE6

At current state i could not found any exeptional entries, which may cause the
latency.




Comment 9 Martin Hollmichel 2007-05-22 14:46:39 UTC
Created attachment 45316 [details]
sources used for initial add/commit
Comment 10 Martin Hollmichel 2007-05-22 14:49:20 UTC
Created attachment 45317 [details]
script to add a new line to all files, and measure time for commit
Comment 11 Unknown 2007-10-22 08:43:36 UTC
Since this project has been on hold for quite some time. I am marking this issue
as Resolved Remind for now until such time the project receives more traction.
Comment 12 Unknown 2009-01-23 11:05:50 UTC
CollabNet Support is currently reviewing the issues under Resolved-Later/Remind. 
Comment 13 Unknown 2009-01-23 11:06:59 UTC
Marking as Invalid as of now
Comment 14 Mechtilde 2009-07-12 18:27:16 UTC
invalid -> closed