Re: How to query 100 primary keys at once

2018-07-05 Thread Goutham reddy
Thank you Jeff for the solution.

On Thu, Jul 5, 2018 at 12:01 PM Jeff Jirsa  wrote:

> Either of those solutions are fine, you just need to consider
> throttling/limiting the number of concurrent queries (either in the
> application, or on the server side) to avoid timeouts.
>
>
>
> On Thu, Jul 5, 2018 at 11:16 AM, Goutham reddy  > wrote:
>
>> Hi users,
>> Querying multiple primary keys can be achieved using IN operator but it
>> cause load only on single node and which inturn causes READ timeout issues.
>> Calling asynchronously each primary key is also not a right choice for big
>> partition key.
>> Can anyone suggest me best practice to query it and if Cassandra is not
>> the right fit for these type of queries which NoSQL dB solves this problem.
>> Any help is highly appreciated
>>
>> Thanks,
>> Goutham,
>> T- Mobile.
>> --
>> Regards
>> Goutham Reddy
>>
>
> --
Regards
Goutham Reddy


Re: How to query 100 primary keys at once

2018-07-05 Thread Jeff Jirsa
Either of those solutions are fine, you just need to consider
throttling/limiting the number of concurrent queries (either in the
application, or on the server side) to avoid timeouts.



On Thu, Jul 5, 2018 at 11:16 AM, Goutham reddy 
wrote:

> Hi users,
> Querying multiple primary keys can be achieved using IN operator but it
> cause load only on single node and which inturn causes READ timeout issues.
> Calling asynchronously each primary key is also not a right choice for big
> partition key.
> Can anyone suggest me best practice to query it and if Cassandra is not
> the right fit for these type of queries which NoSQL dB solves this problem.
> Any help is highly appreciated
>
> Thanks,
> Goutham,
> T- Mobile.
> --
> Regards
> Goutham Reddy
>