On Tue, Feb 5, 2013 at 8:09 PM, Richard Hipp <d...@sqlite.org> wrote:
> > > On Tue, Feb 5, 2013 at 7:43 PM, Jason Gauthier <jgauth...@lastar.com>wrote: > >> I built the table on the same system with mysql. > > > Have you tried using SQLite4 (http://www.sqlite.org/src4)? You should be > able to download the latest check-in and type ./configure; make to build a > shell in which to run the experiment. I think it might be a lot faster in > your case. Would love to hear about your results from trying this > experiment. > Also, please try your speed measurement using SQLite3 again, but in WAL mode. Set WAL mode by running: PRAGMA journal_mode=WAL; on the database before running the speed trial. I look forward to seeing the results of these experiments. > > >> >> Jason >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > d...@sqlite.org -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users