jeudi 17 décembre 2015

How to add a very large amount of data in my android app?

OVERVIEW: I have a database that contains more than 128,000 records, and each record contains about 12 columns (8 string columns with lengths of about 1-2 words each column, and 4 image columns).

GOAL: What I want basically is that when the user chooses a chapter contained in a spinner, the app shall retrieve the data relevant to the chapter chosen and display it on the screen (this is oversimplification though).

WHAT I DID but FAILED:

  1. Creating a class for each column. (This taught me, in the hard way, the 64KB limit thing in java.)
  2. Creating an xml resource file for each column. (Failed because apparently, there's a limited number of ID, in effect resources, in an app)

WHAT I'M PLANNING TO (LEARN AND) DO:

  1. Create an SQLite Database. (But I worry how would I prepopulate it with my data? Wouldn't this lead to the 64KB limit error?)

  2. Create a text file for each column and store them as raw resources then retrieve them using input stream. (I, TBH, don't know what I'm talking about here. I picked this up while reading some sites yesterday).

So, what should I do?

BTW: I am a beginner to both Java and Android (about 2-3 weeks) but picked them up fairly quickly because I got some programming background (Excel VBA mainly) and I'm pretty talented math-wise and programming-wise. I am almost done with my app except this current problem of mine.

THANK YOU.

Aucun commentaire:

Enregistrer un commentaire