On 12 Jun 2017, at 4:20pm, Simon Slavin <slav...@bigfraud.org> wrote:
> Please add the ANALYZE command after your existing VACUUM. Before. Not after. Do ANALYZE, then VACUUM. It might make no difference but technically it may yield a faster result. Or a smaller file. Something good. > This can noticeably speed up any future operations on your database. Yup. Any big change or conversion of data should end up with ANALYZE; VACUUM . Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
