You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Eduardo Cusa <ed...@usmediaconsulting.com> on 2014/09/01 23:21:37 UTC
EC2 - Performace Question
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
Re: EC2 - Performace Question
Posted by Redmumba <re...@gmail.com>.
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.cusa@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-user@incubator.apache.org mailing list archive
> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/> at
> Nabble.com.
>
Re: EC2 - Performace Question
Posted by "eduardo.cusa" <ed...@usmediaconsulting.com>.
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
cassandra-user@incubator.apache.org] <
ml-node+s3065146n7596577h26@n2.nabble.com> 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 cassandra-user@incubator.apache.org, email
> ml-node+s3065146n3065146h65@n2.nabble.com
> To unsubscribe from cassandra-user@incubator.apache.org, click here
> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3065146&code=ZWR1YXJkby5jdXNhQHVzbWVkaWFjb25zdWx0aW5nLmNvbXwzMDY1MTQ2fC04NTYyNzA1NQ==>
> .
> 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: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/EC2-Performace-Question-tp7596568p7596580.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.
Re: EC2 - Performace Question
Posted by Stephen Portanova <sp...@gmail.com>.
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 <jo...@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" <mi...@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
Re: EC2 - Performace Question
Posted by Johnny Miller <jo...@gmail.com>.
Try turning on query tracing to see what's taking lots of time.
> On 1 Sep 2014, at 23:54, "Laing, Michael" <mi...@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 <ed...@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-user@incubator.apache.org mailing list archive at Nabble.com.
Re: EC2 - Performace Question
Posted by "Laing, Michael" <mi...@nytimes.com>.
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.
>
Re: EC2 - Performace Question
Posted by "eduardo.cusa" <ed...@usmediaconsulting.com>.
yes, is the same table, my mistake.
On Mon, Sep 1, 2014 at 6:35 PM, Laing, Michael [via
cassandra-user@incubator.apache.org] <
ml-node+s3065146n7596569h78@n2.nabble.com> 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 cassandra-user@incubator.apache.org, email
> ml-node+s3065146n3065146h65@n2.nabble.com
> To unsubscribe from cassandra-user@incubator.apache.org, click here
> <http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3065146&code=ZWR1YXJkby5jdXNhQHVzbWVkaWFjb25zdWx0aW5nLmNvbXwzMDY1MTQ2fC04NTYyNzA1NQ==>
> .
> 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: 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 at Nabble.com.
Re: EC2 - Performace Question
Posted by "Laing, Michael" <mi...@nytimes.com>.
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
>