Hi,
Actually searching functionality is not limited to search for your data from all column. if you have small database then it's fine. but when you have trillions of data and you would like to search for particular string it may take more time.
One of the example is : if i have search string "c# linq", and your have some records in your database. you display the result records in grid. Now next day again i need to search for the same string, and user have to wait for similar time. as it should not happen.
I think below are some major points that you need to consider
1) Store your search result and give them rating, once you have more resultsets in your table(this table will store rowindex/table information.) you can remove extra search string on bases of that ranking.
2) you need to use
SOUNDX[
^] for similar searching.
3) You can also implement
Extended search method[
^](similar in your Stored procedure)
4) Use indexing to improve performance.
5) Get only desired records from database. if you have pagesize 10 in your datagrid then you can fetch only 10 records for every call. do not return all resultset.
If you implement some or all of the above features then you have powerful searching engine for your site. there are more features can be implemented but initially you can use above very quickly.
Best luck
Thanks
-Amit Gajjar
Submit an article or tip