Re: Cassandra Poor Read Performance Response Time

2016-11-02 Thread Jens Rantil
Hi, I am by no means an expert on Cassandra, nor on DateTieredCompactionStrategy. However, looking in "Query 2.xlsx" I see a lot of Partition index with 0 entries found for sstable 186 To me, that looks like Cassandra is looking at a lot of sstables and realize too late that they don't conta

Re: Cassandra Poor Read Performance Response Time

2016-11-01 Thread Kant Kodali
+1 On Tue, Nov 1, 2016 at 2:10 AM, _ _ wrote: > Hi > > Currently i am running a cassandra cluster of 3 nodes (with it replicating > to both nodes) and am experiencing poor performance, usually getting second > response times when running queries when i am expecting/needing millisecond > response

Cassandra Poor Read Performance Response Time

2016-11-01 Thread _ _
Hi Currently i am running a cassandra cluster of 3 nodes (with it replicating to both nodes) and am experiencing poor performance, usually getting second response times when running queries when i am expecting/needing millisecond response times. Currently i have a table which looks like: CREAT