At the moment, we're using sql server full text search, but it's too inflexible. The main thing we do is look up names of people from a database based on a search query. The searches need to be fast, ...
As far as I know, Apache Solr Lucene project is a web-app which is used for rich text searching. I just wanted to know: Why can't I use MySQL for that and just for rich text searching, why we use ...