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 <d...@sqlite.org> wrote:
> On Thu, Aug 18, 2011 at 11:19 PM, Tarun <er.tarun.9...@gmail.com> 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 around issues
> with fsync(). These days, using "PRAGMA journal_mode=WAL" does a better job
> of overcoming the same issue.
>
> So I suggest that you drop the test_async.c module and instead enable
> "PRAGMA journal_mode=WAL". See if that doesn't work out better for you.
> And if not, we'll take up the problem from that point....
>
>
>> 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
>> sqlite3_exec()
>>
>> Then I did sqlite3async_run() to commit all write request from
>> pending queue to SQLite DB file on disk.
>>
>> Then I did deletion of records from table using DELETE sql query in
>> sqlite3_exec()
>>
>> Then I ran VACUUM command this way:
>>
>> sql = "VACUUM;";
>> rc = sqlite3_exec(asyncsql.pdb, sql, NULL, 0, &zErrMsg);
>>
>>
>>
>> After successful running of above command I checked size of my
>> SQLiteDB file using system ("ls -lrt");
>>
>> NOTE: No compilations issue. async IO code file and sqlite shared
>> library linked properly. All sqlite3_exec() ran successfully with
>> SQLITE_OK, no error code returned.
>>
>> Given below is output shown:
>>
>> [tarun@emu async_prg]$ ./sqlite_async_compKey vacum1.db 1000
>>
>> 1313661267 1313661269 1313661316
>> system1 -> Size of file after records insertion
>> -rw-r--r--. 1 tarun tarun 559104 Aug 18 15:25 vacum1.db
>>
>> system2 -> Size of file after records deletion
>> -rw-r--r--. 1 tarun tarun 559104 Aug 18 15:25 vacum1.db
>>
>> VACUUM SQLite API SUCCESS
>> system3 -> Size of file after VACUUM command
>> -rw-r--r--. 1 tarun tarun 559104 Aug 18 15:25 vacum1.db
>>
>> My problem is why SQLiteDB file size is not reduced after VACUUM has
>> been run. Please help to get VACUUM running in my case.
>> It would be really helpful if anyone can share working demo program
>> using VACUUM.
>> Waiting for your response, I am stuck in my work.
>> --
>> Thanks and Regards,
>> - Tarun Thakur
>> Module Lead
>> NEC HCL System Technologies, Noida
>> www.nechclst.in
>> _______________________________________________
>> 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
>
--
Regards,
- Tarun Thakur
Module Lead
NEC HCL System Technologies, Noida
www.nechclst.in
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
