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

<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