CODEWITHSUNDEEP
sqlite
user575219
user575219

Reputation: 2442

Sqlite blob size

My SQlite DB seems to be bigger than I estimated. How can I check the distribution or whats causing this. It has some BLOB fields. Even after deleting the BLOB data, size doesn't seem to change

Thank u Sun

Upvotes: 1

Views: 489

Answers (1)

Raymond Tau
Raymond Tau

Reputation: 3469

Did you try to run the vacuum SQlite command? This should rebuild the DB, bring down the size.

Upvotes: 2

Related Questions