Home » Topic » How to Shrink SQLite Database?

How to Shrink SQLite Database?

Stephen West ~ Modified: August 26th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to Shrink SQLite Database?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • August 26, 2015 at 10:21 am #522 Score: 0
    Stephen West
    Moderator
    4 pts

    Once done storing all of my data into SQLite, it reach 14 MB already. That’s why I’m afraid that some people cannot download my application from connection slow area.

    Is there any way to shrink SQLite database?

    August 27, 2015 at 12:35 pm #526 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    SQLite database format trades space efficiency for speedy access. If you just dump the data contents, either as SQL dump or simply a CVS file for each database table, you’ll likely get smaller files, either using database files or plain data, try compressing them.

    August 28, 2015 at 10:12 am #534 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    14mb is very large for an Android app still, it’s better if you can arrange for it to be downloaded from a server and integrated into the app.

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