Originally from the User Slack
@Sven: I want to maximize read performance. I have an existing Scylla database with time series. I am streaming the data from it. I am using 1 query SELECT * from table_name and I am letting it run, having set client-side request timeout to 10 years. I am processing page by page.
In this scenario, should I use consistency level TWO or THREE in order to distribute reads across replicas?
Or maybe I am mistaken, perhaps TWO would mean that two replicas need to answer and agree on the result before the read is completed, which would probably lead to slower reading?
@avi: CL=LOCAL_QUORUM is recommended. CL=LOCAL_ONE is faster, but can return stale data. If you can tolerate stale data that’s okay.