subversion-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Sperling <s...@elego.de>
Subject Re: Apparent "svn rm" scaling problem in 1.7.x
Date Tue, 01 Nov 2011 18:00:57 GMT
On Tue, Nov 01, 2011 at 11:31:35AM -0600, michael_rytting@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

Mime
View raw message