2011/11/9 Black, Michael (IS) <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
