cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Portanova <sport...@gmail.com>
Subject Re: EC2 - Performace Question
Date Tue, 02 Sep 2014 05:46:45 GMT
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.miller@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.laing@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.cusa@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-user@incubator.apache.org mailing list archive
>> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/> at
>> Nabble.com.
>>
>


-- 
Stephen Portanova
(480) 495-2634

Mime
View raw message