Let's not forget that the size of the database is going to grow above and beyond the "number of rows" due to pages that aren't reserved for your data, such index pages, etc.
On Tue, May 28, 2019 at 1:49 PM Jens Alfke <j...@mooseyard.com> wrote: > > > > On May 26, 2019, at 7:21 PM, John Brigham <mrph...@juno.com> wrote: > > > > The size of the file reflects the number of rows that should be > present. And furthermore, the size of the file nicely reflects the number > of days. […] Trust me when I say that this file is way to big for the > number of rows. > > SQLite files can contain free space after rows are deleted. (The free > space will eventually be reused for new data, or it can be reclaimed using > the VACUUM pragma.) So the size of the file does not necessarily reflect > the amount of data it currently contains. > > Try opening a copy of the database with the `sqlite3` CLI tool and > entering “PRAGMA vacuum;”. Then exit and look at the file size. > > —Jens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
