fulltext search with mysql FT or Sphinx

问题:

I have read many articles about Sphinx or Solr or MySQL FT. I have a table with over 1 milion products and need to make an fulltext search and get results under 1 second ... . Does anyone has any experience with those kind of fast search? As clint language I am using PHP.

As capacity I have debian5 8GB ram 4 core cpu's.

Thanks Nik

回答1:

We've made some Sphinx performance measurements that are described here http://www.ivinco.com/blog/plain-rt-and-mixed-indexes-performance-comparison/ As it can be seen searching in 1M dataset can be as fast as less than 0.1 sec per query. So I suggest you to use Sphinx.