Re: [sqlite] VACUUM command not working

2011-08-19 Thread Tarun
Thank you so much Richard. I have tried WAL and then applied VACUUM, it is working fine. Thanks again, Tarun Thakur On 8/19/11, Richard Hipp wrote: > On Thu, Aug 18, 2011 at 11:19 PM, Tarun wrote: > >> Hi All, >> >> I am running program in which I have created SQLite DB file using: >> >> sqlit

Re: [sqlite] VACUUM command not working

2011-08-18 Thread Richard Hipp
On Thu, Aug 18, 2011 at 11:19 PM, Tarun wrote: > Hi All, > > I am running program in which I have created SQLite DB file using: > > sqlite3async_initialize() > The easiest solution to your problem might be simply to not use the test_async.c module. That module was created long ago to work aroun

[sqlite] VACUUM command not working

2011-08-18 Thread Tarun
Hi All, I am running program in which I have created SQLite DB file using: sqlite3async_initialize() sqlite3_open_v2() Then created one table into SQLiteDB by using sqlite3_exec() in which I passed SQL command of creating table. Then I inserted records into table using INSERT sql command in sql