Definitely 50 concurrent queries, possibly in async mode. If you're using the IN clause with 50 values, the coordinator will block, waiting for 50 partitions to be fetched from different nodes (worst case = 50 nodes) before responding to client. In addition to the very high latency, you'll put the stress on the coordinator memory.
On Sat, Oct 4, 2014 at 3:09 PM, Robert Wille <rwi...@fold3.com> wrote: > I have a table of small documents (less than 1K) that are often accessed > together as a group. The group size is always less than 50. Which produces > less load on the server, one query using an IN clause to get all 50 back > together, or 50 concurrent queries? Which one is fastest? > > Thanks > > Robert > >
