SQLite도 vacuum이 있다. 기본적으로 활성화 되지 않는 것 같다.
How to vacuum sqlite database?
I want to know how to vacuum sqlite database.
I tried a syntax MANUAL VACUUM command for the whole database from command prompt: $sqlite3 database_name “VACUUM;”;
But it’s giving error as: near ”
I tried a syntax MANUAL VACUUM command for the whole database from command prompt: $sqlite3 database_name “VACUUM;”;
But it’s giving error as: near ”
방법은 매우 단순하다. SQLite 에서 vacuum을 입력하거나 터미널 입력 창에서 입력해준다.
# sqlite3 finance_data.db "vacuum;"
or
sqlite> vacuum;