dimanche 4 janvier 2015

Android Large DB Scenario

I'm dealing with a scenario where the SQLite database is ~80 MB after VACUM cmd.


I know a lot will say thats a huge size for an app (I've seen people complaining about 10MB DBs) - however the app needs that data.


Currently I include a zip in the Assets folder and then unzip to externalStorageDirectory on user's device. After zipping with 7zip, 80MB becomes 7MB, so the app download size is still reasonable.


Are there any additional best practices I should follow to perhaps reduce DB size further? Is this the preferred approach when dealing w/ DBs of this size?


Aucun commentaire:

Enregistrer un commentaire