cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eduardo Cusa <eduardo.c...@usmediaconsulting.com>
Subject EC2 - Performace Question
Date Mon, 01 Sep 2014 21:21:37 GMT
Hi All. I Have a Cluster in Amazon with the following settings:

* 2 Nodes M3.Large
* Cassandra 2.0.7
* Default instaltion on ubuntu

And I have one table with 5.000.000 rows:


CREATE TABLE track_user ( userid text, trackid text,date text ,advid text,
country text, region text,
                        PRIMARY KEY( (trackid,advid , country,
region),userid ));


When run  the following query take *20 **seconds * to finish :

cqlsh:usmc> select count(*) from userpixel where trackid = 'ab1' and advid
= 'adb1' and country = 'AR' and region = 'C' limit 5000000;


Is this time normal?

There are any way to improve the response?


Thanks
Eduardo

Mime
View raw message