Try turning on query tracing to see what's taking lots of time.
> On 1 Sep 2014, at 23:54, "Laing, Michael" <michael.la...@nytimes.com> wrote: > > Is there a reason why updating a counter for this information will not work > for you? > >> On Monday, September 1, 2014, eduardo.cusa >> <eduardo.c...@usmediaconsulting.com> wrote: >> yes, is the same table, my mistake. >> >> >>> On Mon, Sep 1, 2014 at 6:35 PM, Laing, Michael [via [hidden email]] >>> <[hidden email]> wrote: >>> Is table track_user equivalent to table userpixel? >>> >>>> On Monday, September 1, 2014, Eduardo Cusa <[hidden email]> 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 >>> >>> >>> If you reply to this email, your message will be added to the discussion >>> below: >>> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/EC2-Performace-Question-tp7596568p7596569.html >>> To start a new topic under [hidden email], email [hidden email] >>> To unsubscribe from [hidden email], click here. >>> NAML >> >> >> View this message in context: Re: EC2 - Performace Question >> Sent from the cassandra-u...@incubator.apache.org mailing list archive at >> Nabble.com.
