title: What's the effective way to compact sqlite3 db?
body: <p>After a few delete and insert, our sqlite3 was inflated from 300K to over 4MB. In firefox sqlite3 manager, we open the db and compact it. There is no size change. Then we move the db file to a server which responses to sqlite3 command. We did (following <a href="http://lzone.de/How%20to%20Vacuum%20SQLite" rel="noreferrer">post</a> (by Lars Windolf) on VACUUM): </p>
  
  <pre><code>$sqlite3 /path/to/db/mydb.sqlite3 "VACUUM;"
  </code></pre>
  
  <p>However there is no size reduction at all. We are kind of running out of idea. What's the effective way doing compact of sqlite3? Thanks.</p>