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

Re: wc_db performance (was: wc_db API discussion)

From: Paul Burba <ptburba_at_gmail.com>
Date: Sun, 13 Mar 2011 23:31:38 -0400

On Sat, Mar 12, 2011 at 7:47 AM, Stefan Sperling <stsp_at_elego.de> wrote:
> On Fri, Mar 11, 2011 at 10:43:46PM -0500, Greg Stein wrote:
>> 2011/3/11 Branko Čibej <brane_at_e-reka.si>:
>> >...
>> > For the second task, I think the first order of business is to change
>> > the wc-db tree crawler to do one query instead of zillions, or at least,
>> > where several queries are required, to do them all in one transaction.
>>
>> stsp has been working this recently. Killing the node walker, and
>> moving to table scans.
>
> Yes. So far, I've been working in the revision status code.
> There are two problems left to fix before I'll move on to the next task:
>
>  - There are API layering issues (wc_db.c calls into node.c).
>   This is related to the API discussions in the other thread
>   so I'll follow up there.
>
>  - The revision status code issues about 5 separate queries,
>   which aren't combined via a transaction and don't use temporary tables.
>   This is no worse than the previous code using the node walker,
>   obviously :)  But I'll look at fixing this so that the results
>   returned correspond to the state of the DB as of the time the
>   svn_wc__db_revision_status() call was made.
>
> For others who want to jump in and help, here is a list of places
> where the node walker is still being used. I'm not sure if we can
> eliminate it everywhere before release, but each of these should
> be looked at to see whether we can use an alternative approach to
> increase performance:
>
>  subversion/libsvn_client/changelist.c
>  subversion/libsvn_client/commit_util.c
>  subversion/libsvn_client/info.c

>  subversion/libsvn_client/merge.c
> subversion/libsvn_client/mergeinfo.c

I'll dive in Monday morning and see what I can do with merge.c and mergeinfo.c.

Paul

>  subversion/libsvn_client/prop_commands.c
>   (This should be propget and propset. Proplist is already using
>    queries involving temporary tables. Rewriting propget on top
>    of the proplist code would be easy. Propset needs more work.)
>  subversion/libsvn_client/ra.c
>  subversion/libsvn_wc/update_editor.c
>
Received on 2011-03-14 04:32:14 CET

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