On 9 Nov 2011, at 9:02pm, Black, Michael (IS) wrote: > However, reboot again and add "select count(*) from a;" as the first line of > gendat2.sql > > time sqlite3 index.db <gendat2.sql > 1100000 > 2.389u 1.123s 0:07.39 47.3% 0+0k 0+0io 0pf+0w > That's faster than the 2nd run before rebooting.
Out of interest, if you have the time, instead of doing "select count(*) from a;" can you just copy the file to another file ? Possibly read-a-block-write-a-block ? I'm curious to know whether this makes a difference. I have tried some of these things on a Mac, but rebooting doesn't make anything like so much difference on a Mac. It's slower without the reboot but faster with the reboot. However, I don't have a Mac to play with which isn't also acting as a server. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
