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.