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:
- Creating a class for each column. (This taught me, in the hard way, the 64KB limit thing in java.)
- 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:
-
Create an SQLite Database. (But I worry how would I prepopulate it with my data? Wouldn't this lead to the 64KB limit error?)
-
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