狮身人面像比MySQL默认的全文搜索更高效多少？ [英] how much more performant is sphinx than MySQL default fulltext search?

问题描述

当数据量很大时，MySQL的默认全文搜索很糟糕。

所以我指望狮身人面像摆脱麻烦。

是否有可用于比较这两种搜索的基准数据？

解决方案

这个声称50-100倍，高达1000倍，而这个有更加激烈的结果。我已经在dbs上使用过，并且根据我的经验，实际上没有比较;你不能使用FULLTEXT作为大型数据库，而狮身人面像既快速又准确。

MySQL's default fulltext search sucks when the data volume is big.

So I'm counting on sphinx to get rid of the trouble.

Is there a benchmark data available that compares these two kinds of searches?

解决方案

This claims 50-100x, up to 1000x, while this has even more drastic results. I've used both on dbs, and in my experience, there really isn't a comparison; you just can't use FULLTEXT for a large database, while sphinx is both fast and accurate.

这篇关于狮身人面像比MySQL默认的全文搜索更高效多少？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！