On Wed, 2 Apr 2014 09:09:58 -0700 Kevin Xu <accol...@gmail.com> wrote:
> > On Apr 2, 2014, at 9:01 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > > > On 2 Apr 2014, at 4:55pm, Kevin Xu <accol...@gmail.com> wrote: > > > >> PRAGMA journal_mode=MEMORY; > > > > Since you're not using WAL mode, try it using WAL mode. If you > > were already using WAL mode, I'd suggest trying with it off ! > > > > Given your answers to the questions so far, I can't think of > > anything else to try you haven't already thought of. The result > > you report don't seem unusual in any way. I'm not looking at them > > and thinking you've done anything wrong. > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Yes, I have tried various combinations of WAL/OFF/MEMORY and they do > not appear to affect the insert speed in any meaningful manner (e.g. > +/- 0.3s on 500K inputs). > > However, http://blog.quibb.org/2010/08/fast-bulk-inserts-into-sqlite/ > appear to to achieve an average of over 150K inserts per second over > 4 million rows. I am aware that benchmark results are highly > dependent on input size, platform, and hardware, I would imagine the > SSD I am running on would not be such a tight bottleneck. Thus, I am > trying to see if there is anything I can do to improve on this. Perhaps he has 2 disks, first for read FASTQ, second for write sqlite db. > > Kevin --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users