使用 mysql FT 或 Sphinx 进行全文搜索 [英] fulltext search with mysql FT or Sphinx

问题描述

我读过很多关于 Sphinx 或 Solr 或 MySQL FT 的文章.我有一个包含超过 100 万种产品的表格，需要进行全文搜索并在 1 秒内获得结果......有没有人有这种快速搜索的经验?作为 clint 语言，我使用的是 PHP.

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.

作为容量，我有 debian5 8GB ram 4 core cpu.

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

谢谢尼克

推荐答案

我们已经进行了一些 Sphinx 性能测量，在此处进行了描述 http://www.ivinco.com/blog/plain-rt-and-mixed-indexes-performance-comparison/可以看出，在 1M 数据集中搜索每个查询的速度可以低于 0.1 秒.所以我建议你使用Sphinx.

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.

这篇关于使用 mysql FT 或 Sphinx 进行全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！