Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

I just searched for the same but didn't get the answers. What I have is a db file which is around 100MB. I have saved the db file in sdcard .

Through this db file I'm going to populate the contents for the android app. I can read the db file using like below.

File dbfile = new File("/sdcard/Your_db_File.db" ); 
SQLiteDatabase  db = SQLiteDatabase.openOrCreateDatabase(dbfile, null);

What I'm concerned is about the memory. I have read like in assets it has some memory limitations. I'm just worried like will 100MB of db file in sdcard or external memory is a harm or is it OK to have 100MB db file? Or is there any limitations for sqlite db file in external storage as well? Suggestions are appreciated.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

SQLite itself has no problem with 100mb databases, as you can see here it can handle upwards of 140TB in a single database file.

As for Android, each system has different constraints since various providers can decide how much physical memory to install along with which apps run at startup, etc.

I imagine there should be little problem with a 100mb database since that is effectively quite small, however the only real way to know would be to test it on a variety of target devices in a variety of scenarios.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.