cassandra is good if you have way more data then your RAM size. It beats SQL database 10:1 ratio at cost low flexibility for queries.
if dataset fits into memory and data used in test almost fits into
memory then cassandra is slow compared to other leading nosql databases,
it can go up to 10:1 ratio. Check infinispan benchmarks. Common use
pattern is to use memcached on top of cassandra.
- cassandra vs couchbase benchmark Radim Kolar
- RE: cassandra vs couchbase benchmark Viktor Jevdokimov
- Re: cassandra vs couchbase benchmark Radim Kolar
- Re: cassandra vs couchbase benchmark Edward Capriolo