您的自由文本搜索和排序解决方案是什么？
AFAIK，MySQL 在这方面表现非常糟糕，
你的解决方案是什么？
顺便说一句，SO的解决方案是什么？
编辑
请注意，自由文本搜索本身在 MySQL 中相当快，
但当结果还需要按属性排序时则不然！
AFAIK,MySQL performs really bad at this,
what's your solution?
BTW,what's the solution of SO?
EDIT
Please pay attention that free-text search itself is pretty fast in MySQL,
but not the case when the result also needs to be sorted on an attribute!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
Apache SOLR (Lucene) 非常强大。
Apache SOLR (Lucene) is pretty capable.
我认为堆栈溢出在后台使用 SQL Server 以及数据库提供的内置全文搜索功能。 Oracle 提供了 Oracle intermedia (Oracle 9i)，后来称为 Oracle Text，它集成得非常好且高效。 Postgresql 提供了一个名为 tsearch2 的标准内置模块。我不确定 MySql，但看看我提到的其他 3 个数据库，全文确实很复杂，并且作为一项功能需要时间才能成熟。
I think stack overflow uses SQL Server in the background with the built in fulltext search capabilities offered by the database. Oracle offers Oracle intermedia (Oracle 9i), later called Oracle Text, which is very well integrated and efficient. Postgresql offers a standard built-in module called tsearch2. I'm not sure about MySql, but looking at the other 3 databases I've mentioned, fulltext is something that is certainly complex and takes time to mature as a feature.
我推荐 Sphinx Search ：需要配置并对代码进行一些修改，但确实值得。
在拥有超过 100 万条消息的论坛上，全文搜索只需几毫秒。
I recommend Sphinx Search : needs to be configured and some modifications to your code, but really worth it.
On a forum with 1+ million messages, a full-text search takes just a few milliseconds.
SO 使用 Microsoft SQL Server 的全文搜索功能，在播客和博客中多次提到（例如：https://blog.stackoverflow.com/2008/11/sql-2008-full-text-search-problems/）在这篇博客文章中，Jeff 提到可能将来会迁移到 Lucene.net。
我目前正在评估 Haystack 和 Solr 的搜索功能。在几个项目中。
SO uses the full-text search capabilities of Microsoft SQL Server, it's been mentioned several times in the podcast and on the blog (ex: https://blog.stackoverflow.com/2008/11/sql-2008-full-text-search-problems/) In this blog entry, Jeff mentions possibly moving to Lucene.net in the future.
I'm currently evaluating Haystack and Solr for searching. in a couple of projects.