Question
suresh sm on Wed, 01 Jun 2016 11:51:24
I would like to provide the search results quickly from SQL server database.
We can use search engines but it doesn't search from my SQL Server/MySQL database directly. Typically it creates indexes and store the data in document and it searches its own database (text file). In these cases, need to optimize or re-index periodically to reflect the recent changes. Therefore I don't want to use search engines Lucerne or Elastic.
Need to query the database with the entered keyword and return the corresponding content to the end user quickly.
Technologies: Asp.Net MVC + SQL Server
Please share your suggestions .
suresh sm
Replies
Olaf Helper on Wed, 01 Jun 2016 18:45:04
Hello,
You can write SQL statements to search for data in a table, with an index it performs very well. For a more flexible search you can use Full-Text Search as a build-in feature.
suresh sm on Thu, 02 Jun 2016 11:04:41
Thanks for your response we will try with full text search.