On 7 Feb 2014, at 6:35pm, Raheel Gupta <raheel...@gmail.com> wrote: > As you may see that there is now 25% data deleted in each page. > > Now even if I do insert another 2500 rows (25% of original size) my > database size reaches 125% of the original size when I inserted the 10000 > rows initially. > > Hence there is significant space wastage. Anyway i can improve that ?
Whenever filespace matters to you, do a VACUUM. Some apps do it on startup. Some do it on shutdown. Some do it as part of a monthly maintenance period. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users