12 Feb 2011 10:27:40 -0500
> To: sqlite-...@sqlite.org; sqlite-users@sqlite.org
> Subject: [sqlite] SQLite version 3.7.6 testing
>
> The scheduled release of SQLite version 3.7.6 is mid-April. We are still
> two months away. However, version 3.7.6 will contain a lot of pent-up
>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
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
-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
-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
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.
_
-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
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
The scheduled release of SQLite version 3.7.6 is mid-April. We are still
two months away. However, version 3.7.6 will contain a lot of pent-up
changes and so your advance testing of this release will be appreciated.
The latest pre-3.7.6 code can be found here:
http://www.sqlite.org/draft/d
9 matches
Mail list logo