I found out that doing a: sqlite3 my.db .dump > mydump.sql rm my.db sqlite3 my.db < mydump.sql
is faster than doing a VACUUM on my.db. Are there any advantages of doing one over the other? My goal is to keep the database's structures in their best shape for performance and integrity. So I want to run this process every once in a while. jp --------------------------------- Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
