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

2017-12-08 Thread Branko Čibej
On 08.12.2017 12:40, Evgeny Kotkov wrote: > Bert Huijben writes: > >>> The recent SQLite versions (starting from 3.8.2, released in December 2013) >>> feature a `WITHOUT ROWID` optimization [1] that can be enabled when >>> creating a table. In short, it works well for tables that have non-integer

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

2017-12-08 Thread Evgeny Kotkov
Bert Huijben writes: >> The recent SQLite versions (starting from 3.8.2, released in December 2013) >> feature a `WITHOUT ROWID` optimization [1] that can be enabled when >> creating a table. In short, it works well for tables that have non-integer >> primary keys, such as >> >> name TEXT PR

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

2017-12-08 Thread Bert Huijben
> -Original Message- > From: Evgeny Kotkov [mailto:evgeny.kot...@visualsvn.com] > Sent: donderdag 30 november 2017 17:45 > To: dev@subversion.apache.org > Subject: [PATCH] Use the `WITHOUT ROWID` SQLite optimization for rep- > cache.db > > Hi all, > &

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

2017-12-03 Thread Evgeny Kotkov
Evgeny Kotkov 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 >

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

2017-11-30 Thread Evgeny Kotkov
Hi all, The recent SQLite versions (starting from 3.8.2, released in December 2013) feature a `WITHOUT ROWID` optimization [1] that can be enabled when creating a table. In short, it works well for tables that have non-integer primary keys, such as name TEXT PRIMARY KEY by not maintaining t