[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
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)?
This is an archived mail posted to the Subversion Dev mailing list.