Optimize an SQLite database file

article #914, updated 485 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 :-)

Categories:   Databases