If I were to design such an app, I would only pull the data I needed at that moment. Are you going to use 4000 rows of data in one swoop or are you using a subset of that query? Most likely, your app is going to have a "next/previous" type setup. Sucking up 4000 rows from the database will not only be time consuming but also require a lot of memory, battery power and CPU. Pulling only what you need is far more efficient.
-John Coryat -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
