Hi Pavel, Thanks for the information . I am using all insert under one transection hence may be the reson its not effecting much . But do you suggest me the way to increase more insert speed what i need to do in this scenario. Is same happen for all pragma like Page_Size or Journal_Mode or Cache_size ? i tried to change the values of all pragma but i think no one effect the spped .
In case i will bind the values and only prepare the stament once then do you think any improvement ? Cheers kritesh On Tue, Aug 28, 2012 at 7:43 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > 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 > -- Regards kritesh tripathi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
