Thank you for your reply. Pragma wal_checkpoint gave reduced file size. But I still dont know why DB file size increased when I deleted all records .. Can you please clarify this issue?
Thanks in advance. On 04-Jan-2012 5:42 PM, "Richard Hipp" <d...@sqlite.org> wrote: On Wed, Jan 4, 2012 at 6:52 AM, Tarun <er.tarun.9...@gmail.com> wrote: > Hi All, > > I am running p... The size of the database file is not representative of the amount of content in the file while there is an active write-ahead log. Run "PRAGMA wal_checkpoint;" after doing your inserts and/or after running VACUUM to get the true database size. > > Then I ran VACUUM command. > > SQLite file size remained 113664, it did not get reduced. >... > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ 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