[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: 1.7-based nightlies and performance

From: Hans-Emil Skogh <Hans-Emil.Skogh_at_tritech.se>
Date: Mon, 31 May 2010 15:08:44 +0200

>> The following things are pretty slow in the latest nightly:
>> - Check for modifications.the tortoisesvn wc.)
>> - Diffing folder properties
> That is purely a SVN performance issue.
> Currently, it takes 1.3 million SQL queries
> to read the status of a TSVN working copy.
 
Yikes! That's horrible!

> My preliminary analysis of the code in
> question suggests that this number can
> be brought down to roughly 1.3 thousand
> (yet slightly more complex) queries.
 
This sounds pretty hefty too, but clearly a great improvement.

> So, not all hope is lost but it will take a while
> for the SVN guys to address the problem.
 
Oh, this must be solved. I hope. A productivity killer of this scale is just won't do for SVN, which is already on the slow side of things... :-/

> All we can do right now is to provide them
> with analysis results which I will by weekend.

 
Good luck! If you care to post the analysis here as well (or a link to the post) I would be happy to read it as well. 1.3 million queries. That sounds plain crazy!
 
Hans-Emil

------------------------------------------------------
http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=757&dsMessageId=2615271

To unsubscribe from this discussion, e-mail: [dev-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2010-05-31 15:08:59 CEST

This is an archived mail posted to the TortoiseSVN Dev mailing list.