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.
2
Answers
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.
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