Tell us what kind of speed you're seeing. And what your insert looks like. Then tell us what you expect.
Then we can tell you if your expectations are reasonable or if you're already getting as much speed as one can expect. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: [email protected] [[email protected]] on behalf of kritesh tripathi [[email protected]] Sent: Tuesday, August 28, 2012 10:04 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Pragma Synchronous=OFF is not working 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 <[email protected]> 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 <[email protected]> > 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 > >> <[email protected]> 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 > >>> [email protected] > >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> _______________________________________________ > >> sqlite-users mailing list > >> [email protected] > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > > > > > -- > > Regards > > kritesh tripathi > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Regards kritesh tripathi _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
