Mobile Local Storage Maximum Database Size

Mobile Local Storage Maximum Database Size

  

Hi guys, 

Do you know what is the limit size of the Local Storage?

I know that it is SQL Lite. In the official document, it could be more than terabytes, of course a mobile it is unreal, but Do you know if Android, for exemplo apply a limit and what is this limit?

http://www.sqlite.org/limits.html

Hi Tiago,

Not sure, but I think the limit is based on the ammount of free storage you have.
And this will depend on where you are installing the application, as the database will be in the same place.

So, if you install in the internal storage, it will be your limit. If you install the application in an external card, there will be your limit.

In any case, at this point, you should keep your mobile storage "tight", with only the information required to the user to work with it.

Cheers

Hi Tiago !

@Eduardo just said it all. It's just a matter of where will you install the application. I would suggest to user external since the internal can be small (in most of the cases) depending on your goals for this application,but keep in mind:

  1. Make use of the table indexes. Query's can be optimized by creating appropriate indexes.
  2. Make sure to delete all the data you don't really need and keep deleting records that are not used for a long period. 

Best regards,

Diogo Romero

Thaks guys

Your comments were very useful.

Best regards

Tiago Vital