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

Re: Really lousy performance with svn info --depth infinity

From: Philip Martin <philip.martin_at_wandisco.com>
Date: Thu, 01 Sep 2011 18:55:44 +0100

<michael_rytting_at_agilent.com> writes:

> -> sqlite3 .svn/wc.db "select parent_relpath, count(*) AS n from nodes group by parent_relpath order by n desc limit 1"
> ip/DESIGNWARE/verilog|211

That's about 2.5 times the size of a Subversion trunk wc, both in number
of nodes and biggest directory.

If I "svn add" a few hundred files in one directory of my working copy
increasing the total number of nodes by about 33% the runtime of the
recursive info call increase by about 70%. So that indicates that we
have a scaling problem, and I suspect the ORDER/GROUP part of
STMT_SELECT_NODE_CHILDREN_WALKER_INFO. I don't know whether that is
enough to explain the extreme runtime you are getting.

-- 
uberSVN: Apache Subversion Made Easy
http://www.uberSVN.com
Received on 2011-09-01 19:56:18 CEST

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