Re: svn commit: r1022931 - in /subversion/trunk/subversion/libsvn_wc: status.c wc-queries.sql wc_db.c wc_db.h

On Fri, Oct 15, 2010 at 4:19 PM, <philip_at_apache.org> wrote:
> Author: philip
> Date: Fri Oct 15 14:19:36 2010
> New Revision: 1022931
>
> URL: http://svn.apache.org/viewvc?rev=1022931&view=rev
> Log:
> Implement status using per-dir queries.  On my machine (Linux, local
> disk) this improves the speed of status on a Subversion trunk working
> copy by a factor of 3, with a hot-cache, and about 30% with a cold cache.
> 1.7 is still slower than 1.6 for the hot-cache (but it's less than 100%),
> but for cold-cache 1.7 is now faster than 1.6.

Now, that's more like it!

On my machine (WinXP, 32 bit, local disk 5400 rpm), with a medium size
working copy (944 dirs, 10286 files; same as I used in previous tests
([1])):

- cold cache: 1.7 is almost 50% faster than 1.6
1.7: 22s
1.6: 42s

- hot cache: 1.7 is just about on par with 1.6 (only 20% slower)
1.7: 0.86s
1.6: 0.72s

Great work, Philip (and all the others who brought us up to this point
of course)!

Cheers,

-- 
Johan
[1] http://svn.haxx.se/dev/archive-2010-09/0067.shtml