I have my main form in my application and it may contain up to 4 listviews. When I say may, I am using the devexpress layout control and the user may customize the form and remove any/all of the listviews if they are not relevant for their usage.

Now one of the listviews takes the most time to populate. At around 19 seconds for the whole form to load, I can't say I am happy with it. I have done a heap of stuff refining what is returned from the DB and also used Beginupdate and Endupdate and this has made some difference I have gained about 8 seconds off the original start-up time.

My rowpopulating event has some relatively simple coding in there to test values and display in a different colour where necessary.

Now, I am loading around 8000 items, which yes, is a lot (but some msdn guys are loading tens of 000's) and they may not be used, so I would like to look at the possibility of using VirtualMode or maybe do you have a paging method for the listview?

Ideally, I would like to be able to load the listview off a background thread, but I think I know where that would lead.

Ideas appreciated.

Thanks in advance

Geoff Hirst

If you ever do an example for populating a listview off a thread, that would be great.

I have discovered that the it is not good practice to place a seektoprimary key, on a large table in a rowpopulating event. (I heard the sound of Doh!).

Other than that, I tried to do what you said, using a delegate to populate the listview but I just couldn't see what the eventual benefit was going to be, given that any population of the LV has to be done off its creating thread, so surely there is little if any benefit from doing this?

Given the work spent over the last 24 hours, got the form load time down from over 30 seconds to 4. So, it was worth the exercise.

thanks

G.