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?
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.