I have a number of items(800-1000) in a SQL Server database and currently I have my searching arrangement as follows. I have 5 radio buttons that the user selects and then a text box and a listbox. The user starts to type into the text box and as the user types, the change event searches the database for matching items to what the user has entered so far. The radio buttons are to allow the user to select what field to search by. This all works fine, but the search is a bit slower that I would like. What is happening now is that as the user types, I do a select statement to fill a recordset and then populate the listbox from the resulting recordset.
My question then is: Is there a faster way to do this?
Is it faster to do a filter of some sort? My guess would be that I would create a recordset based on the search field, then filter the recordset as the user types rather than connect to the database each time.
Is there a control that I am not aware of that does this sort of thing faster than using recordsets?
Any thoughts on how to improve the speed would be helpfull.
Thanks
My question then is: Is there a faster way to do this?
Is it faster to do a filter of some sort? My guess would be that I would create a recordset based on the search field, then filter the recordset as the user types rather than connect to the database each time.
Is there a control that I am not aware of that does this sort of thing faster than using recordsets?
Any thoughts on how to improve the speed would be helpfull.
Thanks