Hi Michael, Righ Now i am inserting only 500 records in three different tables in 42 sec . I have 500 imagesor video (.jpg or MP4) in the SD card which i am parsing and then inserting one by one in the video table or image table . I am expecting this in between 10-20 sec . Presently i am using the Micro itron embedded RTOS in my device .
Cheers kritesh On Tue, Aug 28, 2012 at 8:48 PM, Black, Michael (IS) <michael.bla...@ngc.com > wro te: > 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: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of kritesh tripathi [tripathi.krit...@gmail.com] > 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 <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 > _______________________________________________ > 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
