Re: svn commit: r1084001 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql

On 03/21/2011 06:38 PM, rhuijben_at_apache.org wrote:
> Author: rhuijben
> Date: Mon Mar 21 22:38:48 2011
> New Revision: 1084001
>
> URL: http://svn.apache.org/viewvc?rev=1084001&view=rev
> Log:
> Simplify and correct a query to allow it to be executed as 5 normal subqueries
> instead of a huge join. I think it needs a bit more optimization, but I hope
> this improves commit performance a bit for now.

Not much. My 30s no-op commit of trunk drops to 24s with this change.
That's still abysmal. Subversion 1.6 does the same in 0.15s. Yeah.

Now, I use a sparse checkout of the ^/subversion directory, pulling in
^/subversion/branches/1.5.x, ^/subversion/branches/1.6.x, and
^/subversion/trunk. So, I guess I have about 3x as many rows in my wc.db
'nodes' table as other folks do. But still, commits in that same working
copy a couple of weeks ago didn't feels as if they were taking anywhere near
as long as they are today.

-- 
C. Michael Pilato <cmpilato_at_collab.net>
CollabNet   <>   www.collab.net   <>   Distributed Development On Demand