How To Optimize SQLite Databases Using The Vacuum Command On Ubuntu Linux

Video is ready, Click Here to View ×


How To Optimize SQLite Databases Using The Vacuum Command On Ubuntu Linux

When you drop database objects such as tables, views, indexes, and triggers or delete data from tables, the database file size remains unchanged. Because SQLite just marks the deleted objects as free and reserves it for the future uses. As a result, the size of the database file always grows in size.

VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the…

Be the first to comment

Leave a Reply

Your email address will not be published.


*