Re: How to perform Range Queries in Cassandra

2014-07-06 Thread Jens Rantil
Ramirez, If you partition your data correctly speed will be ~proportional. But there's always an upper limit - a slow range query that executes on a single node (using cluster key) will always be a slow. Cheers, Jens — Sent from Mailbox On Sun, Jul 6, 2014 at 8:04 AM, Rameez Thonnakkal w

Re: How to perform Range Queries in Cassandra

2014-07-05 Thread Rameez Thonnakkal
Won't the performeance improve significantly if you increase the number of nodes even in a commodity hardware profile. On 5 Jul 2014 01:38, "Jens Rantil" wrote: > Hi Mike, > > To learn get subsecond performance on your queries using _any_ database > you need to use proper indexing. Like Jeremy sa

Re: How to perform Range Queries in Cassandra

2014-07-04 Thread Jens Rantil
Hi Mike, To learn get subsecond performance on your queries using _any_ database you need to use proper indexing. Like Jeremy said, Solr will do this. If you'd like to try to solve this using Cassandra you need to learn the difference between partition and clustering in your primary key and

Re: How to perform Range Queries in Cassandra

2014-07-04 Thread Mike Carter
Does it mean, that Cassandra is not useful for any count queries on more than one columns? 2014-06-24 15:21 GMT+02:00 Jeremy Jongsma : > You'd be better off using external indexing (ElasticSearch or Solr), > Cassandra isn't really designed for this sort of querying. > On Jun 24, 2014 3:09 AM, "M

Re: How to perform Range Queries in Cassandra

2014-06-24 Thread Jeremy Jongsma
You'd be better off using external indexing (ElasticSearch or Solr), Cassandra isn't really designed for this sort of querying. On Jun 24, 2014 3:09 AM, "Mike Carter" wrote: > Hello! > > > I'm a beginner in C* and I'm quite struggling with it. > > I’d like to measure the performance of some Cassa

How to perform Range Queries in Cassandra

2014-06-24 Thread Mike Carter
Hello! I'm a beginner in C* and I'm quite struggling with it. I’d like to measure the performance of some Cassandra-Range-Queries. The idea is to execute multidimensional range-queries on Cassandra. E.g. there is a given table of 1million rows with 10 columns and I like to execute some queries l