How to load ListBox with a lot of data?

V

vnarod

Regular
Joined
Mar 22, 2002
Messages
84
I am sure everyone ran into this problem at some point. Is there a good solution?
I need to show records from database in a listbox or a grid. Number of records is about 50,000 and it will take too long to load them into listbox. What is the way to do it?
 
have you considered only showing a certain number of records at a time? granted it's not what you wanna do but it would speed things up
 
Load only a portion of the records at a time. When the user reaches either end of the current list, give them the option to display the next set of records, or do so automatically. It is far too impractical to load all 50,000 records at once, and there's no reason to do so. If you're coding for a client who wants all the records shown at once give them a demo of how long it'll take to display 50,000 records. That'll shut them up. ;)
 
Back
Top