2011/11/9 Black, Michael (IS) <michael.bla...@ngc.com> OK...you're right...a reboot kills it. >
I'm glad someone was able to reproduce this on Linux, ruling out the possibility it's a Windows-issue. > However, reboot again and add "select count(*) from a;" as the first line > of gendat2.sql > So if a simple SELECT COUNT(*) can speed up the same insert from 90 seconds to 7 seconds (including the count), does this confirm it's a sequential vs random reads problem? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users