Lazy loading from SQLite

Question

I have some 4500 entries in my database. What is the best way to show them in a ListView. Should I load them all in one stretch when the application initializes or should I use lazy loading? The list will also be searchable and filterable. Could you also point me to some nice articles that would gimme a better idea. Please do give me suggestions.

I haven't used lazy loading before, please do point to articles that might be of help to me. — Ragunath Jawahar
– Ragunath Jawahar, Commented Oct 24, 2010 at 15:29
Given that it is a mobile application, you should definitely not load all the entries in one go... Use something algorithm to get ONLY the relevant data perhaps using a search, or some sort of pagination support for the data to acquire data by chunks of 20 - 50 rows at a time — Jude Cooray
– Jude Cooray, Commented Oct 24, 2010 at 15:35
@RagunathJawahar Hi. I do have the same prob. I have like 1000 items in database and wanted all the items in a listView and the list view is both searchable and filterable. What approach did u follow.? is it good to have Lazy loading.? If yes, how can i achieve search and filter on ListView adapter on lazy loading.? — suresh cheemalamudi
– suresh cheemalamudi, Commented Jan 8, 2013 at 5:58

Andrew White · Accepted Answer · 2010-12-03 17:57:38Z

6

I would like to point you to here first but I also have some experience I would like to share.

First, showing anything more than say 500 items in a list is probably going to cause users to complain (maybe not though). Users can get overwhelmed with info and it gets annoying for users to scroll to see all of the data (even with filters because some users will refuse to use them if they can scroll).

Second, the data adapter in Android is pretty smart so an adapter over thousands of items will be handled smoothly due to the way Android caches views and iterates through a result set with a cursor which is the subject of that link I pointed you to at the start of my answer.

answered Dec 3, 2010 at 17:57

Andrew White

53.6k20 gold badges116 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Lazy loading from SQLite

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related