Count(*) queries are very inefficient - you'll want to take Michael's advice and use counter tables
On Mon, Sep 1, 2014 at 9:26 PM, Johnny Miller <johnny.p.mil...@gmail.com> wrote: > 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] >> <http://user/SendEmail.jtp?type=node&node=7596570&i=0>] <[hidden email] >> <http://user/SendEmail.jtp?type=node&node=7596570&i=1>> wrote: >> >>> Is table track_user equivalent to table userpixel? >>> >>> On Monday, September 1, 2014, Eduardo Cusa <[hidden email] >>> <http://user/SendEmail.jtp?type=node&node=7596569&i=0>> 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] >>> <http://user/SendEmail.jtp?type=node&node=7596570&i=2>, email [hidden >>> email] <http://user/SendEmail.jtp?type=node&node=7596570&i=3> >>> To unsubscribe from [hidden email] >>> <http://user/SendEmail.jtp?type=node&node=7596570&i=4>, click here. >>> NAML >>> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >>> >> >> >> ------------------------------ >> View this message in context: Re: EC2 - Performace Question >> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/EC2-Performace-Question-tp7596568p7596570.html> >> Sent from the cassandra-u...@incubator.apache.org mailing list archive >> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/> at >> Nabble.com. >> > -- Stephen Portanova (480) 495-2634