Home » Topic » How to check SQLite BLOB Size?

How to check SQLite BLOB Size?

Lincoln Burrows ~ Modified: September 19th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to check SQLite BLOB Size?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 19, 2015 at 10:38 am #681 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    My SQlite Database 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.

    September 21, 2015 at 12:31 pm #701 Score: 0
    Stephen West
    Moderator
    4 pts

    For a binary blob? That would be in violation of the SQLite documentation which says blobs are treated as text and as such length() is accurate only until it finds a \0 character

    September 22, 2015 at 12:14 pm #710 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Try to run vacuum SQlite command.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.