Another one of these "solution needed for the workplace" type of blog entries. First, I know - putting nearly 100,000 items in a control might suggest an alternative method, but accept that it's the right solution for the moment. There... don't we feel better?
Now, the situation is that I need to populate a listing type of control with between 80,000 and 100,000 items. Honestly, I would have gladly used a combobox or a listbox, just as long as it provided some means to come up quickly.
It surprised me that creating the collection of items could be so quick yet populating the control was so slow. But, I've come to accept that fact and went searching for a control that was a bit 'smarter' about its contents.
What I found was a Virtual ListBox implemented on vbAccelerator.com. It fits the bill well for my needs. The only thing to add to it is the ability to accept keyboard input to quickly move to items in the list. That is on the docket for next week .