search results from database quickly

Category: sql server search


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


Olaf Helper on Wed, 01 Jun 2016 18:45:04


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.