[RESOLVED] Loading 5000 records into a listbox

[dee-u]

Are you really sure you want to load all those 5000 records in the listbox at once?

[Rudie]

Hi,

Not all the time, but if I want to see all the customers it will display 5000. Also, whether I display the ones in credit or debit, it takes the same amount of time.

Thanks.

[dee-u]

30 seconds for 5000 records is really slow, would you care to post the code you are using? And what database are you using?

[szlamany]

My suggestion, as I am sure Dee-u was leading towards, is to never load 5000 records into any control.

That is simply too many.

No user is ever going to scroll through 5000 of anything.

It would be an easier experience to have an A to Z list - some kind of drill down - tree view maybe - whatever you can imagine.

We personally "halt" filling any and all textboxes at 251 entries and flash a message that the user is being too vague. Entering SMITH for a lookup name in a database with 20000 rows and getting 300 SMITH's in a drop-down list is not a appropriate.

[Rudie]

Ok, i try and trim down the 5000.

database is VDM access 2.0 but having problems converting to ADO at the moment

[Hack]

Ok, i try and trim down the 5000.

database is VDM access 2.0 but having problems converting to ADO at the moment

What kind(s) of problems?

[Rudie]

I have always used ms access/vdm on small data like less than 100 records. but nw i been told to use ADO, but do i have to modify the database? or is it just a code change when to database is openned and accessed or written to? Beacon sent me a doc on how to use ADO but i keep getting the message:

Runtime Error '-2147467259 (80004005)':
Couldn't find installable ISAM