Performance Problems - Loading Listviews

[GuyBooth]

I am building an app that has 4 sliding panels loaded on the AHViewer. Test results below are based on a Galaxy S3.

One of the panels contains a CustomListView which loads approx 1000 records from a SQLLite database. This takes about 10 secs to load, and may be reloaded in different record order at user request. The CustomListView functionally does everything I need but this load time is way to long. The SQL execution is not the problem, it is really quick - the long load time is a result of loading the CustomListView.

The other panel in question contains a "standard" ListView which loads approx 6000 records from the same database. This takes 4 - 5 secs to load but functionally barely achieves what I need (lack of the persistant color change on a "selected" item being one of the problems). This load time is also longer than I would like, especially since it always happens immediately after the CustomListView loading - it's the nature of the app.
Are there any solutions to these slow load times? Any threading options I should consider? Any caching solutions? I am not technically good enough to build libraries, but I can modify Classes ok and building classes would not be a problem.

 

[Informatix]

Informatix - a couple of questions on ULV:
Can I add an array to each list item (as I can in the CLV) in addition to text?
I saw somewhere a description of having the fast scroll display the first letter of the displayed item. Will I be able to make it display the first letter from a different an element which is part of the array in question 1?

Thanks

1) Each item can hold what you want. There's no predefined layout.

2) An event is triggered when the first visible item changes. You do what you want with this event. You can display the first letter of the first visible item, a counter showing how many items have been seen, a value associated to the item in the middle, etc., or nothing.