Sphinx + NoSQL Help

Question

Hey,

So I'm looking to run Sphinx over a NoSQL system such as MongoDB, HBase, Cassandra, etc.

Right now, we're comparing all the NoSQL systems out there. Basically, we need to query 50+ Million rows of product data with fulltext searches thousands of times a second, so we're trying to find the most efficient NoSQL system.

Here is our question, though. If we use any NoSQL system with Sphinx, when we perform the actual searches, will the search have any interaction with the NoSQL system itself, or will Sphinx be doing the work as it has the data indexed? If it's only Sphinx, then wouldn't the performance of the NoSQL system be only secondary?

Thanks!

Answer 1

Using the latest string attribute, you can cut of the database part of the search completely, that will be much more efficient.