On 6/10/15, Igor Stassiy <istassiy at gmail.com> wrote: > Hello, > > I have a question about controlling the size of sqlite database containing > records of the form id -> payload where payload has fixed size and id is an > integer column. > > I am developing a simple storage for points in an sqlite database, the > problem is that space consumption on disk is slightly unsatisfying.
Have you use the sqlite3_analyzer.exe utility (available for download from https://www.sqlite.org/download.html) to see how the space in your database file is being used? -- D. Richard Hipp drh at sqlite.org