svn commit: r1340706 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql

[rh...@apache.org]

Author: rhuijben
Date: Sun May 20 12:59:58 2012
New Revision: 1340706

URL: http://svn.apache.org/viewvc?rev=1340706&view=rev
Log:
Improve query performance for revert handling.

* subversion/libsvn_wc/wc-queries.sql
  (STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE): Assume never called on the wcroot,
    and the node itself doesn't have to be changed. This to allow removing
    an OR that makes this statement use a table scan.
    (Assumptions are valid for the only user of this query).

Modified:
    subversion/trunk/subversion/libsvn_wc/wc-queries.sql

Modified: subversion/trunk/subversion/libsvn_wc/wc-queries.sql
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-queries.sql?rev=1340706&r1=1340705&r2=1340706&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Sun May 20 12:59:58 2012
@@ -876,11 +876,11 @@ SELECT wc_id, local_relpath, ?3 /*op_dep
 FROM nodes
 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
 
+/* Not valid on the wc-root */
 -- STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE
 UPDATE nodes SET op_depth = ?3 + 1
 WHERE wc_id = ?1
-  AND (?2 = ''
-       OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
+ AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
  AND op_depth = ?3
 
 -- STMT_DOES_NODE_EXIST