I am running dse with -s option and I am using Thrift API to fetch data from my solr indexed fields. I observed that when I try to fetch data from Cassandra using any of the below mentioned methods, the subsequent response from server becomes very slow if I use same Thrift connection.
select F1 from CF1 where KEY > 'XX' and solr_query='F2:2'
I change the value of KEY (XX) in every subsequent query so as to fetch the entire data set in batches
1. Run CQL query using Thrift API execute_cql_query()
2. Use Thrift's get_indexed_slices()
HTTP APIs response time is good.