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

Reply via email to