6 ms·
If search performance and accuracy is the criteria of choosing the data store, how does riak+riak search compare with mysql+sphinx ?
by boundlessdreamz 16y ago
If search performance and accuracy is the criteria of choosing the data store, how does riak+riak search compare with mysql+sphinx ?
- sjs 16y agoThe Sphinx website mentions scaling but just throws numbers out there without mentioning scaling out. Assuming it is distributed you'd have to run benchmarks with your data and queries to really know how it'll perform against Riak Search for any given number of nodes. If it's not distributed then Riak search can outperform it with enough nodes, without question. The question then becomes how many nodes. I'd love to see some benchmarks on this sort of thing if anyone is up to it.
- rb2k_ 16y agoIt is WAY easier to scale (up AND down) over several nodes. So if you've got BIG amounts of text that you have to fulltext-search, Riak might be the better option.
- bravura 16y agoAnd, for good measure, could you compare RiakSearch to horizontally scaling Lucene? And ElasticSearch, if you are familiar with it?
- samratjp 16y agoIMO, this is one of the better discussed comparisons on the whole Lucene sharding business: http://mail-archives.apache.org/mod_mbox/hbase-user/201006.mbox/%3C149150.78881.qm@web50304.mail.re2.yahoo.com%3E http://mail-archives.apache.org/mod_mbox/hbase-user/201006.m... EDIT: Also, keep an eye on Twitter's Lucene branch - http://engineering.twitter.com/2010/10/twitters-new-search-architecture.html http://engineering.twitter.com/2010/10/twitters-new-search-a...