cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laing, Michael" <michael.la...@nytimes.com>
Subject Re: EC2 - Performace Question
Date Mon, 01 Sep 2014 21:35:17 GMT
Is table track_user equivalent to table userpixel?

On Monday, September 1, 2014, Eduardo Cusa <
eduardo.cusa@usmediaconsulting.com> wrote:

> 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