Great, thanks for your help. I will have a look at that.
On Thu, Aug 31, 2017 at 9:28 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 31 Aug 2017, at 12:10am, Ali Dorri <alidorri...@gmail.com> 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 > 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
