[android-developers] Re: cursor.moveToFirst() & cursor.moveToLast() time consuming issue with sqlite database.

You can "cram" unlimited # of items into a list. It's not like the
list keeps its entire contents around. It asks you for the data as it
needs it and it's up to the app to supply that data via whatever
means.

On Oct 6, 12:46 am, lbendlin <l...@bendlin.us> wrote:
> you won't be cramming these 17000 records into a list anyhow. Simply limit
> your SQL query accordingly so that the cursor holds no more items than you
> can reasonably scroll through.  If you use buttons for navigation then you
> can even recreate the cursor with each button press and still be MUCH
> faster.
>
> Of course, don't forget to index the search criteria.

--
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