I am building an application that will run on a single client machine. Within the application I have included a combo box which may contain anything up to 10,000 records pulled from an Access database. To keep the data within the combo box up to date, should I bind it to a recordset or populate it on the drop down event? If I bind it to a recordset, it would have to be DAO and a server side cursor. Which option would be quickest, and would either of these provide a suitable means of accessing the data in a proffesional application where the client machine may be fairly old?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Proffesional advice on app. design
- Thread starter AGP
- Start date
I would suggest going to the DB as little as possible. Then populate the Drop down on intervals. Say every five minutes or so.
If you wait till they press down, there will be a big delay to get the box. Craig, mailto:sander@cogeco.ca
Remember not to name the Lambs...
It only makes the chops harder to swallow
If you wait till they press down, there will be a big delay to get the box. Craig, mailto:sander@cogeco.ca
Remember not to name the Lambs...
It only makes the chops harder to swallow
What about a phone number search for a customer DB.
Many customers are pulling up your customer Info, via the Phone number even before they answer the phone. Craig, mailto:sander@cogeco.ca
Remember not to name the Lambs...
It only makes the chops harder to swallow
Many customers are pulling up your customer Info, via the Phone number even before they answer the phone. Craig, mailto:sander@cogeco.ca
Remember not to name the Lambs...
It only makes the chops harder to swallow
oops customers = companies....
Many companies are pulling up your customer Info, via the Phone number even before they answer the phone. Craig, mailto:sander@cogeco.ca
Remember not to name the Lambs...
It only makes the chops harder to swallow
Many companies are pulling up your customer Info, via the Phone number even before they answer the phone. Craig, mailto:sander@cogeco.ca
Remember not to name the Lambs...
It only makes the chops harder to swallow
Populating 10,000 Records at one go into a combo dont seem to be agood programming
It is better to filter records based on user input and using "like" operator to fetch mininum records in a grid control or so
any futher calrification
mail to maheshpatil_mp@indiainfo.com
It is better to filter records based on user input and using "like" operator to fetch mininum records in a grid control or so
any futher calrification
mail to maheshpatil_mp@indiainfo.com
First of all, do not bind it. Create a recordset and use GetRows for fastest retrieval with minimum Net traffic.
Now, you have an array of the data - what you do with it is up to you but I wouldn't use a combo box. A list box may start bombing out after a few thousand records. See if you can break the data up by category such as is done in a telephone book. Create the rs based on that.
Now, you have an array of the data - what you do with it is up to you but I wouldn't use a combo box. A list box may start bombing out after a few thousand records. See if you can break the data up by category such as is done in a telephone book. Create the rs based on that.
- Status
