On 03/21/2011 06:38 PM, rhuij...@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 <cmpil...@collab.net> CollabNet <> www.collab.net <> Distributed Development On Demand
signature.asc
Description: OpenPGP digital signature
