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
