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.

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to