My two cents, to complement other answers: leave it to the user. In case of a client-side GUI app, let the user run some maintenance action, like an OS has "defragment disk" action, or Outlook has "compact folders" action. In case of a server-side app, make a script or admin command to do that.
Hope this helps! -- Igor On Wed, Jul 7, 2010 at 1:45 AM, Kristoffer Danielsson <kristoffer.daniels...@live.se> wrote: > > I've been reading the documentation. I've been googling and thinking. > > > > Still, I can't figure out the best way to determine when to run the > VACUUM-command. Note that I do NOT want to enable "auto vacuum". > > I do remember reading something about calculating empty space, used pages etc > etc. Still, no perfect answer. > > > > Q: How do I programmatically (through sqlite-APIs?) determine if it's time to > VACUUM a database? In general, what is the best method here? > > > > Thanks! > > /Chris > > _________________________________________________________________ > Håll skräpposten borta med nya Hotmail. Klicka här! > http://explore.live.com/windows-live-hotmail > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users