Category: Databases

Optimize an SQLite database file
article #914, updated 3065 days ago

Just make sure that no processes are using the file, make a backup of it for safekeeping, and then:

sqlite3 *.db "VACUUM;"

Compare sizes and you’ll see how much you have done!

Very useful to optimize database tables in MyBB with SQLite, among many other purposes :-)