Hello, Simon Slavin <slav...@...> writes: > >[...] > > It that takes 11 hours, that means you're taking about 4ms per INSERT. I don't know if this is unusually high. > You might like to try 'PRAGMA synchronous = OFF' > > <http://www.sqlite.org/pragma.html#pragma_synchronous> > > > sqlite3 -bail extra.db3 < inserts.sql > > I'm not sure about the '-bail' switch for sqlite3. Can you instead add '.bail ON' to the top of your > inserts.sql file ? >
I interrupted the process after 11 hours, integrated your suggestions and started the process again - now its working since more than 5 hours. Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
