Re: svn status is slow under a large check-out

2012-05-07 Thread Bob Cardillo
>Yes, please file an issue so we don't lose track of this. Added. http://subversion.tigris.org/issues/show_bug.cgi?id=4178 >very promising. Thanks a lot for your help. I freely plagiarized from this thread. :) Thanks to all, especially Philip for the great analysis!

Re: svn status is slow under a large check-out

2012-05-07 Thread Stefan Sperling
On Sat, May 05, 2012 at 12:39:05PM -0400, Bob Cardillo wrote: > Thanks for all great info so far! > > >Taking that query out reduces the read() calls back to 99. Do we need > >another SQLite index? Can we improve that query? > > Your index idea was a good one. I used sqlite3 to back up my wc.d

Re: svn status is slow under a large check-out

2012-05-07 Thread Adam D . Walling
Bob Cardillo gmail.com> writes: > CREATE INDEX bobindex1 ON nodes (kind, presence, op_depth) As one of Bob's coworkers, who helped him a bit earlier last week to track down the --non-recursive trick that improved the speed, I had to try this myself after seeing the results of his investigation o

Re: svn status is slow under a large check-out

2012-05-06 Thread Daniel Shahaf
Bob Cardillo wrote on Sat, May 05, 2012 at 12:39:05 -0400: > Your index idea was a good one. I used sqlite3 to back up my wc.db, > then ran the query you found, filling in the parameters as appropriate > and commenting out the use of IS_STRCT_DESCENDENT() since that is a IS_STRICT_DESCENDANT_OF()

Re: svn status is slow under a large check-out

2012-05-05 Thread Bob Cardillo
Thanks for all great info so far! >Taking that query out reduces the read() calls back to 99. Do we need >another SQLite index? Can we improve that query? Your index idea was a good one. I used sqlite3 to back up my wc.db, then ran the query you found, filling in the parameters as appropriate

Re: svn status is slow under a large check-out

2012-05-04 Thread Bob Cardillo
>What does your working copy look like? Do you have svn:externals? Do >you have the sqlite3 tool? What do these commands show: > > sqlite3 .svn/wc.db "select count (*) from actual_node" > sqlite3 .svn/wc.db "select count (*) from nodes" I think my working copy is fairly typical for a very large

Re: svn status is slow under a large check-out

2012-05-04 Thread Philip Martin
Bob Cardillo writes: > I'm running Subversion 1.7.4.50525 (r1295709) on Windows 7 Pro SP1. > > I have a large repository, and for clean development flow I've checked > out the root locally. But because of this, when I do: > svn status C:\mycheckout\trunk\folder1\file1.ext > > it takes a very l

svn status is slow under a large check-out

2012-05-04 Thread Bob Cardillo
I'm running Subversion 1.7.4.50525 (r1295709) on Windows 7 Pro SP1. I have a large repository, and for clean development flow I've checked out the root locally. But because of this, when I do: svn status C:\mycheckout\trunk\folder1\file1.ext it takes a very long time, around 5-6 seconds, to fi