On 9 Jun 2018, at 4:16pm, Ben Asher <benashe...@gmail.com> wrote: > Thanks for that helpful tip on 0/1! We'll definitely use those then.
Good. See section 2.1 of <https://www.sqlite.org/fileformat2.html>. > To further clarify on VACUUM, we actually want to actively avoid this > because it's expensive, and we'd be running these on small devices like > iPhones and iPads with large-ish DBs. That may be the correct decision for your situation. But be aware that SQLite will not always reclaim the released space from the database file when it needs more space. Pay particular attention to your setting for "PRAGMA auto_vacuum". <https://sqlite.org/pragma.html#pragma_auto_vacuum> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
