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 <[email protected]> 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;
