Now when i write "TES" then all the entries in database having that "TES" are shown. Either this keyworld is in the beginnig or in the last or in the
centre.
Fast searching in the large database.
Suppose i have a large database having 1 lakhs entry, and i want to search world by world. for example My name is pritesh.
Sunny SharmaPosted May 26, 2013, 8:59 AM
The very first, if you have a large database then you're advised to have an index on search columns to make queries result much faster.
I suggest to use AJAX for doing this.
Follow this link:
http://www.aspdotnet-suresh.com/2012/03/jquery-ui-autocomplete-textbox-with.html
It's a very nice post.
Please don't forget to accept this as answer if it helps!
Thanks.