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