incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <>
Subject Re: Performance / limitations of WHERE ... IN queries
Date Fri, 26 Apr 2013 02:07:26 GMT
You are effectively doing a multi get. Getting more than one row at a time is normally faster,
but there will be a drop off point where the improvements slow down. Run some tests. 

Also consider that each row you requests creates RF number of commands spread around the thread
pools for the row. If one client req	requests 100's or 1000's then this can delay other client

Aaron Morton
Freelance Cassandra Consultant
New Zealand


On 25/04/2013, at 8:29 PM, Thierry Templier <> wrote:

> Hello,
> I wonder what are the performances of WHERE ... IN queries especially when the number
of elements in the IN grows?
> Thanks very much for your help!
> Thierry

View raw message