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
