I need to create a page which allows the user to search through a database table and return any records which match the keyword entered.
A number of websites I use have a very elegant search function of this nature where it will search any matching surname or forename without needing to specify which one you are looking for and the search is updated in real time each time you add or remove a letter to the search box.
I know mostly what I would need to do to achieve this, I'm just wondering the best way to approach it ... and whether my searches should query the database each time or if I should just pull the entire table into a dataset and then do the search operations on that instead. I imagine the latter might allow for faster searching, though would it still be a wise approach if the db table contained thousands rather than hundreds of users?
A number of websites I use have a very elegant search function of this nature where it will search any matching surname or forename without needing to specify which one you are looking for and the search is updated in real time each time you add or remove a letter to the search box.
I know mostly what I would need to do to achieve this, I'm just wondering the best way to approach it ... and whether my searches should query the database each time or if I should just pull the entire table into a dataset and then do the search operations on that instead. I imagine the latter might allow for faster searching, though would it still be a wise approach if the db table contained thousands rather than hundreds of users?