Re: Apparent "svn rm" scaling problem in 1.7.x

On Tue, Nov 01, 2011 at 11:31:35AM -0600, michael_rytting_at_agilent.com wrote:
> It's just one directory that has 49 files in it.

Good. Please try this patch in addition to the other one.
It makes 'svn rm dir/*' with 49 files go down from about 4.20 seconds
to about 1.50 seconds for me (local disk).

Note that I am not going to commit this as is.
It just tests whether the overhead of sorting paths in sqlite matters
much on NFS.

Index: subversion/libsvn_wc/wc-queries.sql
===================================================================
--- subversion/libsvn_wc/wc-queries.sql (revision 1196149)
+++ subversion/libsvn_wc/wc-queries.sql (working copy)
@@ -1208,7 +1208,6 @@ WHERE wc_id = ?1
 
 -- STMT_SELECT_DELETE_LIST
 SELECT local_relpath FROM delete_list
-ORDER BY local_relpath
 
 -- STMT_FINALIZE_DELETE
 DROP TABLE IF EXISTS delete_list
Received on 2011-11-01 19:01:36 CET