On 19 Sep 2011, at 12:43pm, Stephan Beal wrote: > On Mon, Sep 19, 2011 at 1:41 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> It may or may not speed things up if you do a VACUUM between the DROP and >> CREATE. It should make the file size smaller. > > OTOH, not vacuuming leaves the blocks in place for recycling, which "should" > be faster for subsequent insertions.
Yeah. I get different advantages for this for different types of storage. Rotating disks seem to act better if you reduce the file size. Finding a particular page of a longer file takes longer. However, SSD devices seem to find pages just as fast in a longer file, so, as you write, it makes sense not to free up the block space. However, I was testing on one particular setup only and didn't spend any time investigating the reasons for the timing I saw. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
