Thanks to suugestion I am using the Sqlite version -3.6.4 and support for WAL mode started from version 3.7.0.If i upgrade to recent sqlite version then is any possibilty to increase in performance or any other good idea .
Cheers kritesh On Tue, Aug 28, 2012 at 8:11 PM, Jonathan Engle <jon_en...@kace.com> wrote: > Try WAL mode. > > On Aug 28, 2012, at 9:38 AM, kritesh tripathi wrote: > > > 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 > > _______________________________________________ > 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
