Tuesday, 27 August 2013

Maximum SQLite Database Size in Android Application

Maximum SQLite Database Size in Android Application

I am new to the Android Development.
Currently, I am working on one Android Application having a large amount
of data.
So I have thought that I should have to store some of those data locally.
I have one database having 2 tables.
Table-1's size is: 4.5 MB Table-2's size is: 3.5 MB currently.
i.e. Totally around 8.0 MB but in future database size can be increased
and may be reach to 10 MB.
Table-1: Rows(14927) and Columns(17) Table-2: Rows(9903) and Columns(38)
My doubt is that can i store this much data locally in an android
application or the application's speed can be affect by it.
I don't want to store these data in external storage. And I can't store it
on server database as I have to use these data many times in the
application. While the other data is on server as it must be used
centrally.
This is my point of view. But please give me your suggestions.
What to do if there is such size of database.
Please help me. Thanks in advance...:)

No comments:

Post a Comment