On 31 Aug 2017, at 12:10am, Ali Dorri <[email protected]> wrote:
> It works. I think I should a way to calculate this reduction in the size of
> the database as sometimes it seems there is no difference in size (after
> VACUUM) between removing one row or two or three.
> This is a research work so I need it to show me exactly how much data is
> removed.
SQLite databases are stored as pages of a certain length. Each table, each
index, is a sequence of pages. You can delete some data but unless you free up
an entire page, the file won’t get shorter. You can find out how long a page
is using this command
PRAGMA page_size
documented here:
<https://sqlite.org/pragma.html#pragma_page_size>
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
