Implementing 'Search' functionality on website

Question

I have a website which has thousands of (ever increasing) resources in it. I implemented the usual Sql Full text Search and it was working fine until recently. I noticed some performance issues with it. I am using MySql Database with C#. NET as the back-end code.

I just need few valuable suggestions from you so that I can take those into account while building a new search strategy for my website.

What can I use to improve performance in the search functionality on my site?

Answer 1

You could try out;

http://incubator.apache.org/lucene.net/

Answer 2

Take a look at Lucene.NET. It is a high-performance, full-featured text search engine library which was initially written in Java but ported over to .NET. It is a technology suitable for nearly any application that requires full-text search, especially cross-platform.