I have millions records and have to search a single record from it how to do it on the webpage with good speed. Do remember that my database is already optimized. How will you optimize the search query and speed up the webpage.
Neetu Gangwani
See my post: https://www.c-sharpcorner.com/blogs/how-to-make-faster-sqlserver-search-part-i, wait for a while the part II, that are in revision: https://www.c-sharpcorner.com/blogs/how-to-make-faster-sql-server-search-part-two
using web services, angular js, REST services or WCF service.