On 19 Feb 2020, at 4:36pm, Olivier Mascia <o...@integral.be> wrote: > having an apparently sane database (pragma integrity_check and pragma > foreign_key_check successful at least), it would make sense to do : REINDEX, > ANALYZE and then VACUUM as part of final preparation step for archive (the DB > would be seldom queried later).
That would seem to the a good order in which to do those five things. If I was setting up a new system for customer use, I would give them a maintenance procedure which did those things, let them run it whenever they wanted, but tell them to run it at least once a year. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
