Thanks. The documentation states that this new stat3 is better than stat2. Do
you have any benchmarks or similar that show the win?
> From: d...@sqlite.org
> Date: Tue, 29 Nov 2011 07:21:17 -0500
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Are SQLITE_ENABLE_STAT3 tables created when upgrading?
>
> On Tue, Nov 29, 2011 at 7:00 AM, Kristoffer Danielsson <
> kristoffer.daniels...@live.se> wrote:
>
> >
> >
> >
> >
> > Consider an SQLite database created with the SQLITE_ENABLE_STAT2 flag set.
> > After updating my software, the new SQLite version seems to use another
> > flag; SQLITE_ENABLE_STAT3. Will these stat3 optimizations be available when
> > opening and old database created with stat2? Or is it perhaps necessary to
> > run the ANALYZE command? Thanks.
> >
>
> It is necessary to rerun ANALYZE.
>
>
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
