-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 31/12/12 12:33, Michael Black wrote: > Journaling off might work if you don't have any indexes.
You should create the indexes after inserting the data. If you don't you end up with index data and row data intermingled in the database which makes things slower. Journaling off definitely worked for me when I benchmarked it. I was working with a 15GB dump from postgres on Linux. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlDiABEACgkQmOOfHg372QQesQCgjTJbDb3Yt2iyC/7vUEJAFuTq 1T0AoIPDu/fpdtOoEEnmkNn4vr/lGTpe =bgfW -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users