Re: [sqlite] VACUUM command issue

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" wrote: On Wed, Jan 4, 2012 at 6:52 AM, Tarun wrot

Re: [sqlite] VACUUM command issue

On Wed, Jan 4, 2012 at 6:52 AM, Tarun wrote: > Hi All, > > I am running program in which I have created SQLite DB file using: > sqlite3_open_v2() > > configured it: > > PRAGMA journal_mode = WAL > PRAGMA synchronous=OFF > > Then created one table into SQLiteDB by using sqlite3_exec() in which > I

[sqlite] VACUUM command issue

Hi All, I am running program in which I have created SQLite DB file using: sqlite3_open_v2() configured it: PRAGMA journal_mode = WAL PRAGMA synchronous=OFF Then created one table into SQLiteDB by using sqlite3_exec() in which I passed SQL command of creating table. After configuration, SQLite