[android-developers] How to load/use data from an SQLite db

Hi devs,

This is my first android application, and am confused about how to
proceed with using data from an SQLite database.

The database itself will contain around 20,000 - 25,000 records,
across three or four tables. The information inside the database will
not need to be changed, only read from.

As this is my first android app, I'm confused on how to load this data
into the app itself.

Should I be loading the information from the database into memory on
app-startup, or querying the database every time the user searches for
a record?

Iv'e been looking into using greenDAO to manage the SQLite db for me,
and allow me to query. Am I on the right lines with this?

Any help would be appreciated.

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en