subversion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From danie...@apache.org
Subject svn commit: r1296868 - /subversion/trunk/subversion/libsvn_fs_fs/rep-cache-db.sql
Date Sun, 04 Mar 2012 20:14:01 GMT
Author: danielsh
Date: Sun Mar  4 20:14:01 2012
New Revision: 1296868

URL: http://svn.apache.org/viewvc?rev=1296868&view=rev
Log:
* subversion/libsvn_fs_fs/rep-cache-db.sql
  (I_HASH): New index.

Suggested by: Trent Nelson <trent@snakebite.org>

Modified:
    subversion/trunk/subversion/libsvn_fs_fs/rep-cache-db.sql

Modified: subversion/trunk/subversion/libsvn_fs_fs/rep-cache-db.sql
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_fs_fs/rep-cache-db.sql?rev=1296868&r1=1296867&r2=1296868&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_fs_fs/rep-cache-db.sql (original)
+++ subversion/trunk/subversion/libsvn_fs_fs/rep-cache-db.sql Sun Mar  4 20:14:01 2012
@@ -33,6 +33,11 @@ CREATE TABLE rep_cache (
   expanded_size INTEGER NOT NULL
   );
 
+/* There isn't an implicit index on a TEXT column, so create an explicit one. */
+CREATE INDEX I_HASH on REP_CACHE (hash);
+
+/* The index didn't exist until 1.7.5; therefore, some USER_VERSION=1
+   rep-cache.db files out there DO NOT contain an I_HASH index. */
 PRAGMA USER_VERSION = 1;
 
 



Mime
View raw message