How can i search faster from thousands of records ?

Question

hello guys how r u all?

my question is that, i have 50,000 records in a table and i have to run search query on it , so what is the fastest query to search a record from thousands of records ..

replyy soon


thanks

Answer 1

Hi,

Please check once
http://www.c-sharpcorner.com/Blogs/870/ 
http://www.codeproject.com/Articles/4272/Using-Diagnostics-Process-to-start-an-external-app