> On May 26, 2019, at 7:21 PM, John Brigham <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
