;>>
>>>>>> CREATE TABLE track_user ( userid text, trackid text,date text ,advid
>>>>>> text, country text, region text,
>>>>>> PRIMARY KEY( (trackid,advid , country,
>>>>>> region),userid ));
>>
;>> CREATE TABLE track_user ( userid text, trackid text,date text ,advid
>>>>> text, country text, region text,
>>>>> PRIMARY KEY( (trackid,advid , country,
>>>>> region),userid ));
>>>>>
>>>>>
>>>>> When
seconds * to finish :
>>>>
>>>> cqlsh:usmc> select count(*) from userpixel where trackid = 'ab1' and
>>>> advid = 'adb1' and country = 'AR' and region = 'C' limit 500;
>>>>
>>>>
>>>>
vid
>>>> = 'adb1' and country = 'AR' and region = 'C' limit 500;
>>>>
>>>>
>>>> Is this time normal?
>>>>
>>>> There are any way to improve the response?
>>>>
>>>&g
db1' and country = 'AR' and region = 'C' limit 5000000;
>>>
>>>
>>> Is this time normal?
>>>
>>> There are any way to improve the response?
>>>
>>>
>>> Thanks
>>> Eduardo
>>>
>>
>
gt; 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://
Is table track_user equivalent to table userpixel?
On Monday, September 1, 2014, Eduardo Cusa <
eduardo.c...@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 o
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,
