And if the pages are defragmented heavily, new inserts could result in database size increase until vacuum is performed.?
Sreekumar On Nov 18, 2011 9:38 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > On 18 Nov 2011, at 3:51pm, Sreekumar TP wrote: > > > So if my database grew to 20Mb and later lots of records were deleted > > amounting to 50% of the database size, the size on disk will still be > 20Mb. > > Correct? > > > > Now if I start inserting records, sqlite will use the remaing 50% of disk > > space until it reaches a point where no more free pages or space in pages > > are available to insert data. Is this inference valid? > > Yes and yes. First it will use up the about 10Mb of space you free. If > you're still inserting once all that space is used up (for the second time > !), only then will SQLite make the file bigger. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users