On 23 Oct 2011, at 4:13pm, Bo Peng wrote: > Other than using a SSD to speed up random access, I hope a VACUUM > operation would copy tables one by one so content of the tables would > not scatter around the whole database. If this is the case, disk > caching should work much better after VACUUM... fingers crossed.
VACUUM will defragment, too. Unless your free space is fragmented. So yes, probably a good move. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
