On 2 Sep 2017, at 10:55am, Jacky Lam <[email protected]> wrote:
> Thanks for the answer. I have a clear picture now.I would also like to know > for Android SQLite case;does the default value for auto vacuum is OFF.Is it > the same default compiling config with sqlite.c source code?In other words, > does it need to do vacuum manually? It’s not a good idea to depend on the default setting for auto_vacuum because it may be set differently in the compilation you’re using. It’s safer to set it yourself any time you create a new database. The setting is stored inside the database file and will stick with it unless it is intentionally changed. And please note that you never /need/ to do any kind of VACUUM in a production setting. The only situation where it helps is if your database is significantly shrinking and will not grow again soon, and that’s quite rare for a database. Doing a pointless VACUUM just means you’re wearing out your storage device. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
