On 11 Jan 2011, at 8:00am, Oliver Peters wrote: > I'm on WinXP and using sqlite 3.7.4 with the CLI. I try to insert ~ 10,100,000 > records into a schema with different tables
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 ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
