views:

125

answers:

1

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?

+1  A: 

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.

Todd Gardner