I have a listView associated with a CursorAdapter than can have more than 5k of rows. I am using CursorLoader for the same and it hangs the UI for a long time. I have gone through similar posts that are already present on SO here and here.
I do understand that fetching such a big data and loading it on the UI is very huge to process and load into memory. Saying this, I still need to get it in my adapter.
I have considered using Scrolling Cursor but the other problem that I would go through is while implementing Alphabetical Indexing similar to what Android Contacts app have and which stops me from updating the cursor part-wise
Also, my query makes use of a left-outer join along with an Order by clause
I am hoping there might be some way of doing this. It has already been done in the Android basic apps such as Contacts, Music and so on.