| [PATCH] Use the `WITHOUT ROWID` SQLite optimization for rep-cache.db
From: Evgeny Kotkov <evgeny.kotkov_at_visualsvn.com>
 Date: Thu, 30 Nov 2017 19:44:44 +0300 
Hi all,
 The recent SQLite versions (starting from 3.8.2, released in December 2013)
     name TEXT PRIMARY KEY
 by not maintaining the hidden rowid values and an another B-Tree to match
 Currently, the rep-cache.db schema uses a non-integer primary key:
     hash TEXT NOT NULL PRIMARY KEY
 and can benefit from this optimization.  A quick experiment showed a
 I think that it would be nice to have this optimization in rep-cache.db,
   - All existing rep-cache.db statements are compatible with it.
   - Since SQLite versions prior to 3.8.2 don't support it, we would
 Would there be any objections to a change like this (see the attached patch)?
 [1] https://sqlite.org/withoutrowid.html
 Thanks,
 
 
 | 
This is an archived mail posted to the Subversion Dev mailing list.
This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.