When a large amount of data is deleted from the database file it leaves behind empty space, or "free" database pages. This means the database file might be larger than strictly necessary. Running VACUUM to rebuild the database reclaims this space and reduces the size of the database file.
for %%i in (*.sqlite) do sqlite3 %%i VACUUM | echo %%i
FORFILES /M *.sqlite /S /C "cmd /c sqlite3.exe @file VACUUM | ECHO @file"
[
SQLite Query Language: VACUUM]
Mozilla Links 正體中文版: Firefox 3 日漸肥大的收藏庫：減肥法
Vacuum the Stylish SQLite DB - forum.userstyles.org
