Re: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-19 Thread Philip Martin
"Bert Huijben" writes: > As users that have upgraded to Sqlite 3.8.0 or later have found out our > design choices really affect performance on huge working copies: several > performance critical queries during operations such as commit, delete and > revert are now handled as a full table scan. T

Re: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-18 Thread Philip Martin
"Bert Huijben" writes: > * > But I would also like to recommend/ask that we start bundling Sqlite with > Subversion, to allow optimizing for the specific version we use for a > release without risking future breakage. > * Are we able to get advance notice of SQLite security releases or d

Re: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-17 Thread Branko Čibej
On 18.11.2013 03:50, Justin Erenkrantz wrote: > On Sun, Nov 17, 2013 at 7:34 AM, Bert Huijben > wrote: > > But I would also like to recommend/ask that we start bundling > Sqlite with > Subversion, to allow optimizing for the specific version we use for a > re

Re: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-17 Thread Justin Erenkrantz
On Sun, Nov 17, 2013 at 7:34 AM, Bert Huijben wrote: > But I would also like to recommend/ask that we start bundling Sqlite with > Subversion, to allow optimizing for the specific version we use for a > release without risking future breakage. > If we use the amalgamation, are all of the symbols

Re: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-17 Thread Branko Čibej
On 17.11.2013 14:33, Bert Huijben wrote: > >> -Original Message- >> From: Branko Čibej [mailto:br...@wandisco.com] >> Sent: zondag 17 november 2013 14:08 >> To: dev@subversion.apache.org >> Subject: Re: Using Sqlite in libsvn_wc towards Subversion 1.9+

RE: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-17 Thread Bert Huijben
> -Original Message- > From: Branko Čibej [mailto:br...@wandisco.com] > Sent: zondag 17 november 2013 14:08 > To: dev@subversion.apache.org > Subject: Re: Using Sqlite in libsvn_wc towards Subversion 1.9++ > > On 17.11.2013 13:34, Bert Huijben wrote: > >

Re: Using Sqlite in libsvn_wc towards Subversion 1.9++

2013-11-17 Thread Branko Čibej
On 17.11.2013 13:34, Bert Huijben wrote: > Hi, > > For Subversion 1.8 I spend a lot of time optimizing our use of Sqlite in the > working copy to work as optimal as possible with the then Supported range of > Sqlite versions (3.7.12-3.7.19). Then a few months later in Sqlite 3.8.0 a > new que