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
