PocariSweat1991

Hello!

My application needs to store about 5000 records of data that will never change. An example would be a dictionary of 5000 words.

Initially, I started creating a string-array.xml resource file for these records, but realized that I wanted to associate integer data with each string-array as well.

Therefore, I started looking into the SQLite database for storing these records. This seems like a great option, but I discovered that the database will be created the first time the application runs. This means that the first time a users downloads my application, they will have to wait a *very* long time for the database to build ... which is a horrible user experience.

Are there any other options for defining and storing application data that will never change?

PocariSweat1991

For those interested, I have found an interesting solution in the following blog post:

ReignDesign | Blog - Using your own SQLite database in Android applications

This solution performs a byte-stream transfer of a database in the assets folder, to a new database on the system. I have not tested this yet, but I think it will be faster than INSERT-ing multiple records.