You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@subversion.apache.org by Evgeny Kotkov <ev...@visualsvn.com> on 2017/12/03 17:49:10 UTC

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

Evgeny Kotkov <ev...@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