Tricks to speed up sqlite3 vacuum (2006)

What I learn is pipeing .dump into a new database can be faster than running vacuum for large database on btrfs.<p>Example:<p>(echo &quot;pragma journal_mode=wal;&quot; | sqlite3 db.sqlite3 .dump) | sqlite3 temp.sqlite3; mv temp.sqlite3 db.sqlite3