On 4 Jul 2012, at 10:54am, Hauptmann Peter <hauptma...@yahoo.com> wrote:
> However, they also have rough indicators, whether or not it's necessary > (fragmentation or > a recommendation when closing Outlook) > > Q: Are there any useful indicators to suggest a VACUUM? > (Or, to reverse it: indicators that show VACUUM is not necessary?) I forgot the more useful information: <http://www.sqlite.org/pragma.html#pragma_freelist_count> "PRAGMA freelist_count; Return the number of unused pages in the database file." The bigger this is, the more point there is in doing a VACUUM. Unless the next thing you're going to do is add more data to the database in which case the VACUUM is a waste of time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users