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

Re: [PATCH] Improve speed of recursive info

From: Philip Martin <philip.martin_at_wandisco.com>
Date: Fri, 02 Sep 2011 11:38:10 +0100

Philip Martin <philip.martin_at_wandisco.com> writes:

> Philip Martin <philip.martin_at_wandisco.com> writes:
>
>> 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.
>
> Michael, are you building 1.7 from source? Will you try a patch? The
> following patch against 1.7 addresses the above problem and improves the
> speed of recursive info on my machine:

It looks like we might be able to fix this using another SQL index
rather than changing the C code. You can create the index in an
existing working copy using:

sqlite3 .svn/wc.db "create index i_p2 on nodes(wc_id, parent_relpath, local_relpath, op_depth)"

-- 
uberSVN: Apache Subversion Made Easy
http://www.uberSVN.com
Received on 2011-09-02 12:38:59 CEST

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