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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
