Fast searching in the large database.

Question

Suppose i have a large database having 1 lakhs entry, and i want to search world by world. for example My name is pritesh.

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.

Sunny Sharma · Answer

Hi Pritesh 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.