> On Mar 6, 2017, at 1:30 PM, Richard Hipp <d...@sqlite.org> wrote: > > Have you ever wondered when you should run ANALYZE on an SQLite > database? It is tricky to figure out when that is appropriate. The > new "PRAGMA optimize" command tries to automate the decision for you.
Very nice!! Thanks for implementing this. I noticed one typo in the docs of this pragma: _For_ achieve the best long-term query performance… Should be something like _To_ achieve the best long-term query performance… —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users