Re: [PATCH] Improve speed of recursive info

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