Hi there, I'm running the "pragma auto_vacuum = 'full'" a C++ code, then I go to SQLiteSpy, open the database and run pragma auto_vacuum in the query window and the result is 0. I tried "pragma auto_vacuum = 1" and still the same, it doesn't seem to keep the setting. I have some tables that get written and truncated a lot, and the size of the database grows out of control if I don't clean it up periodically. Please help, any suggestions are highly appreciated.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users