RE: Really lousy performance with svn info --depth infinity
Date: Thu, 1 Sep 2011 10:43:42 -0600
And here is the final comparison using an nfs mounted working copy. This is where the difference gets really bad.
-> time /file_access/subversion/1.6.17/bin/svn info --depth infinity > /dev/null
-> time svn info --depth infinity > /dev/null
> And here is the comparsion of 1.6.17 vs 1.7.0-rc2. This test was run
The recursive "svn info" still does multiple sqlite transactions per-node, that probably explains why it is slower than 1.6. It's doesn't really explain why the single recursive call is slower than multiple non-recursive calls, since each non-recursive call also makes several sqlite transactions.
At first glance the difference between recursive and non-recursive is node.c:walker_helper. Is STMT_SELECT_NODE_CHILDREN_WALKER_INFO missing an index?
-- uberSVN: Apache Subversion Made Easy http://www.uberSVN.comReceived on 2011-09-01 18:44:15 CEST
This is an archived mail posted to the Subversion Dev mailing list.