Re: Slow paging query on Cassandra.

2018-01-27 Thread Avi Kivity
Does the last_update_date constraint filter out a lot of rows? In that case the server may be reading a large number of rows, only to throw them away since they get filtered out. If you apply the filter on the client side, you shouldn't see timeouts (but overall the process will be slower sin

Slow paging query on Cassandra.

2018-01-26 Thread Juan Manuel Alonso
Hi guys, I'm having some trouble while using paged queries on Cassandra's Java driver (version 3.3.2). I'm using Cassandra 3.11.0. I have to fetch a page of data from the DB, then make some trivial changes, and then update these rows. A simplified version of the code i'm running would be: