Re: Performance / limitations of WHERE ... IN queries

2013-04-26 Thread Thierry Templier
Thanks very much, Aaron, for your answer! Thierry 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 c

Re: Performance / limitations of WHERE ... IN queries

2013-04-25 Thread aaron morton
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.

Performance / limitations of WHERE ... IN queries

2013-04-25 Thread Thierry Templier
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