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

Reply via email to