Re: [PATCH] Use the `WITHOUT ROWID` SQLite optimization for rep-cache.db

Evgeny Kotkov <evgeny.kotkov_at_visualsvn.com> writes:

> I think that it would be nice to have this optimization in rep-cache.db,
> and that we can start using it in a compatible way:
>
> - All existing rep-cache.db statements are compatible with it.
>
> - Since SQLite versions prior to 3.8.2 don't support it, we would
> only create the new tables with this optimization in fsfs format 8,
> and simultaneously bump the minimal required SQLite version from
> 3.7.12 (May 2012) to 3.8.2 (December 2013). This would ensure that
> all binaries supporting format 8 can work with the tables with this
> optimization.
>
> Would there be any objections to a change like this (see the attached patch)?

I committed the patch (with a couple of additional tweaks for the
recommended SQLite version and the build scripts) in

    https://svn.apache.org/r1817042

Thanks,
Evgeny Kotkov
Received on 2017-12-03 18:49:44 CET