On 9 Jan 2019, at 2:01pm, spamh...@bluewin.ch wrote:

> In which order should VACUUM, INTEGRITY_CHECK and OPTIMIZE be executed?

If you are in any situation where INTEGRITY_CHECK should be run, do not make 
any changes to the database (e.g. ANALYZE) first.  Those changes might 
overwrite parts of the file that may show that the database was corrupt.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to