Re: [sqlite] SQLite version 3.7.6

2011-04-13 Thread Peter van Dijk
On Apr 12, 2011, at 2:49 PM, D. Richard Hipp wrote: > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ I expect you meant 'now available' :) Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

Re: [sqlite] SQLite version 3.7.6

2011-04-12 Thread D . Richard Hipp
On Apr 12, 2011, at 8:49 AM, D. Richard Hipp wrote: > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ The "not" in the sentence above should be "now", of course. Sorry for the typo. > > Version 3.7.6 is a regularly scheduled bi-monthly maintenance release.

Re: [sqlite] SQLite version 3.7.6

2011-04-12 Thread Oliver Peters
writes: > > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ [...] really not ;-) ? Please don't disappoint your followers. greetings Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-13 Thread Sven L
Lol... we just had a long discussion about sqlite_stat2 and ANALYZE command. I removed these from my code, since the command should not be used except for rare cases :P Should I re-add my ANALYZE-code and ask my original question again? Confused :P > From: d...@sqlite.org > Date: Sat, 12 Feb

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Jean-Christophe Deschamps
>Your goals make a lot of sense. However I think you can do my second >suggestion. Compile with STAT2 code included by default, but make the >analyze command only build stat1 by default. > >This will result in no change in default behaviour, but means that anyone >wanting to use stat2 can easily

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Richard Hipp
On Sat, Feb 12, 2011 at 1:21 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/12/2011 07:27 AM, Richard Hipp wrote: > > ... if SQLite is compiled using SQLITE_ENABLE_STAT2 ... > > Is there any reason this is not turned on by default? > > A key principle of SQL in

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/12/2011 02:13 PM, Richard Hipp wrote: >> But SQLITE_ENABLE_STAT2 breaks that guarantee. With STAT2, the ANALYZE >> command stores a histogram of left-most column of each index in order to >> help it make decisions about whether or not to use tha

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/12/2011 11:40 AM, Simon Slavin wrote: > Does it make the ANALYZE command take significantly longer ? I don't think that matters. If someone runs ANALYZE it is because they are experiencing performance issues using default (non-analyzed) query p

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Simon Slavin
On 12 Feb 2011, at 6:21pm, Roger Binns wrote: > On 02/12/2011 07:27 AM, Richard Hipp wrote: >> ... if SQLite is compiled using SQLITE_ENABLE_STAT2 ... > > Is there any reason this is not turned on by default? Does it make the ANALYZE command take significantly longer ? Simon. _

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/12/2011 07:27 AM, Richard Hipp wrote: > ... if SQLite is compiled using SQLITE_ENABLE_STAT2 ... Is there any reason this is not turned on by default? If it is turned on and then the database is used by an earlier version of SQLite will there be

Re: [sqlite] SQLite version 3.7.6 testing

2011-02-12 Thread Alexey Pechnikov
Please mark snapshots by pre-3.7.6 tag in fossil repository. How about compression in FTS extension? Is this production ready now? 12.02.2011 18:30 пользователь "Richard Hipp" написал: > The scheduled release of SQLite version 3.7.6 is mid-April. We are still > two months away. However, version