On Wed, Feb 08, 2012 at 08:45:56AM -0500, Rob Richardson scratched on the wall: > My deepest apologies for forgetting to change the subject line in my > last post, and thus accidentally hijacking a thread. Here is the > message again, this time with the correct subject. > > On Wed, Feb 8, 2012 at 8:44 AM, Rob Richardson <cedriccic...@gmail.com> wrote: > > Greetings! > > > > Is there a way to verify the auto-vacuum state of an SQLite database? > > I am hoping that auto-vacuum will replace the need for periodic VACUUM > > calls. If the files are getting too big, I need to be able to verify > > the auto-vacuum setting before trying to come with some other scheme > > to prevent unbridled file growth.
PRAGMA auto_vacuum; http://www.sqlite.org/pragma.html#pragma_auto_vacuum Note that auto-vacuum will often make fragmentation issues worse. Even with auto-vacuum in place, it is best to run a full manual vacuum from time to time, especially for highly dynamic databases. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
