On Tue, Nov 29, 2011 at 7:50 AM, Kristoffer Danielsson < kristoffer.daniels...@live.se> wrote:
> > Thanks. The documentation states that this new stat3 is better than stat2. > Do you have any benchmarks or similar that show the win? > No benchmarks. But there are corner cases that stat3 handles well that stat2 does not. On the other hand, there are no cases (that I know of) that stat2 does better than stat3. > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
