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


Sponsored



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.