If all your inserts are in one transaction then pragma synchronous = OFF won't affect your transaction speed too much. To understand whether this pragma works or not you should measure how long it takes to execute COMMIT (just this one statement). With synchronous = OFF COMMIT will be executed much faster.
Pavel On Mon, Aug 27, 2012 at 7:02 AM, tripathi.kritesh <tripathi.krit...@gmail.com> wrote: > Hi , > > I am executing all below mentioned pragma before start the (BEGIN --COMMIT) > transaction in sqlite version (3.6.4) > > sqlite3_exec(mDb, “PRAGMA synchronous=OFF”, NULL, NULL, &errorMessage); > sqlite3_exec(mDb, “PRAGMA count_changes=OFF”, NULL, NULL, &errorMessage); > sqlite3_exec(mDb, “PRAGMA journal_mode=MEMORY”, NULL, NULL, &errorMessage); > sqlite3_exec(mDb, “PRAGMA temp_store=MEMORY”, NULL, NULL, &errorMessage); > > > In transaction , I am inserting the values in the table but I dnt know the > specific reason why does not pragma effecting the insert speed .. I am > getting the same speed even i use the pragma or not . please help > > Is these pragma effect take place in transaction ? > > Cheers > kritesh > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/Pragma-Synchronous-OFF-is-not-working-tp63904.html > Sent from the SQLite mailing list archive at Nabble.com. > _______________________________________________ > 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
