I have a listbox displaying records that match search results. It is multi-column displaying about 10 fields.
Works fine for most searches but since some users have 60,000 records a search for a single character or All Records takes a very long time, up to 20 seconds on some systems. It is not the search it is the fill part.
Because I hide the listbox while filling to speed things up the user is left completely in the dark while waiting making the wait seem even longer or causing user panic (Ctrl- Alt + Del It’s not responding, how do I get out of this?).
Refreshing the listbox every 1000 records looks good but the listbox is useless as you can’t select a record until it finishes anyway and it takes twice as long to fill. Displaying a Wait message box again slows things down.
Any ideas to make this user friendly.
PS. Is filling a row with an array quicker than filling cell by cell? I get inconsistent results, perhaps affected by data size or background programs.