Using query tracing, as many have recommended here, will tell you where the query is spending it's time. If there's a bottleneck somewhere, you'll see it there.
On Tue, Sep 2, 2014 at 6:57 AM, eduardo.cusa < eduardo.c...@usmediaconsulting.com> wrote: > Hi Thanks for the response. > > For that use case, the counter works fine. I'll change it. > > > But for some others use cases what I need to do is to obtain the "full > list" of users : > > cqlsh:usmc> select userid from userpixel where trackid = 'ab1' and advid > = 'adb1' and country = 'AR' and region = 'C' limit 5000000; > > And this query is taking more than, *21 seconds aprox.* > > Could you please confirm if this response time is normal (or usual)? > Because in that case, I´m assuming that we will need to put some kind of > "memmory cache level" like Redis or CouchDB. > > Could you please confirm if I'm ok? > > > > > On Tue, Sep 2, 2014 at 2:47 AM, Stephen Portanova [via [hidden email] > <http://user/SendEmail.jtp?type=node&node=7596580&i=0>] <[hidden email] > <http://user/SendEmail.jtp?type=node&node=7596580&i=1>> wrote: > >> 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 <[hidden email] >> <http://user/SendEmail.jtp?type=node&node=7596577&i=0>> wrote: >> >>> Try turning on query tracing to see what's taking lots of time. >>> >>> On 1 Sep 2014, at 23:54, "Laing, Michael" <[hidden email] >>> <http://user/SendEmail.jtp?type=node&node=7596577&i=1>> wrote: >>> >>> Is there a reason why updating a counter for this information will not >>> work for you? >>> >>> On Monday, September 1, 2014, eduardo.cusa <[hidden email] >>> <http://user/SendEmail.jtp?type=node&node=7596577&i=2>> 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-user@... mailing list archive >>>> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/> at >>>> Nabble.com. >>>> >>> >> >> >> -- >> Stephen Portanova >> (480) 495-2634 >> >> >> ------------------------------ >> 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-tp7596568p7596577.html >> To start a new topic under [hidden email] >> <http://user/SendEmail.jtp?type=node&node=7596580&i=2>, email [hidden >> email] <http://user/SendEmail.jtp?type=node&node=7596580&i=3> >> To unsubscribe from [hidden email] >> <http://user/SendEmail.jtp?type=node&node=7596580&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-tp7596568p7596580.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. >
