change sqlite file size after “DELETE FROM table”

by

The command you are looking for is vacuum. There is also a pragma to turn auto-vacuuming on.

From the documentation:

When an object (table, index, trigger,
or view) is dropped from the database,
it leaves behind empty space. This
empty space will be reused the next
time new information is added to the
database. But in the meantime, the
database file might be larger than
strictly necessary. Also, frequent
inserts, updates, and deletes can
cause the information in the database
to become fragmented – scrattered out
all across the database file rather
than clustered together in one place.

The VACUUM command cleans the main
database by copying its contents to a
temporary database file and reloading
the original database file from the
copy. This eliminates free pages,
aligns table data to be contiguous,
and otherwise cleans up the database
file structure.

More Related Contents:

  1. Accessing an SQLite Database in Swift
  2. How to delete or add column in SQLITE?
  3. Import CSV to SQLite
  4. Select random row from a sqlite table
  5. How to get Top 5 records in SqLite?
  6. Insert new column into table in sqlite?
  7. How do you enable LIMIT for DELETE in SQLite?
  8. Sqlite primary key on multiple columns
  9. SQLite Schema Information Metadata
  10. How to create custom functions in SQLite
  11. SQLite: How do I save the result of a query as a CSV file?
  12. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  13. is there a limit to the size of a SQLite database?
  14. How to generate all dates between two dates
  15. SQLITE_BUSY The database file is locked (database is locked) in wicket
  16. Does it matter what extension is used for SQLite database files?
  17. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  18. How do I DROP a constraint from a sqlite (3.6.21) table?
  19. Sqlite over a network share [closed]
  20. SQLite table constraint – unique on multiple columns
  21. Are there any reserved words in SQLite?
  22. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  23. Modify a Column’s Type in sqlite3
  24. Case sensitive and insensitive like in SQLite
  25. SQLite accent-insensitive search
  26. How to have an automatic timestamp in SQLite?
  27. SELECT INTO statement in sqlite
  28. How to display blob value using x’abc’ binary string literal syntax?
  29. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  30. DbFunctions.TruncateTime LINQ equivalent in EF CORE

Leave a Comment