cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phil Luckhurst <phil.luckhu...@powerassure.com>
Subject Re: RPC timeout paging secondary index query results
Date Fri, 13 Jun 2014 07:34:47 GMT
But would you expect performance to drop off so quickly? At 250,000 records
we can still page through the query with LIMIT 50000 but when adding an
additional 50,000 records we can't page past the first 10,000 records even
if we drop to LIMIT 10.

What about the case where we add 100,000 records for each indexed value?
When we do this for 2 values, i.e. 200,000 records with 2 indexed values, we
can query all 100,000 records for one of the values using LIMIT 100000. If
we add a third indexed value with another 100,000 records then we can't page
through any of the indexed values even though the original 2 that worked
previously have not changed.

Phil



--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/RPC-timeout-paging-secondary-index-query-results-tp7595078p7595126.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Mime
View raw message