Regarding Cassandra Read Performance
<p>I am working on a sensor data(timeseries). Number of columns in a table is 3000.<br>
 for eg: <code>nodeid,timestamp,sen1,sen2,.....sen-n</code>. <code>nodeid</code> and <code>timestamp</code> are primary key with clustering order by timestamp.<br>
Number of records are 10000.</p>

<p>When a SELECT query for single column(<code>SELECT timestamp,sen1 FROM &lt;table&gt;</code>) requ is requsted through cassandra datastax java driver 3.0 it is replies in 15 sec; i.e If I want read all the tags, one a tag at a time for all 3000 tags requires 3000*15 sec = 12 to 13 hours aproximately. <strong>It is on single node cluster</strong> with 16GB RAM.<br>
I allocated 10GB for JVM. Still response time is not changed. I used LevelCompactionStragy at the time of table creation.</p>

<p>Hardware: Intel Core i7 and Normal Hard disk not SSD,8GB RAM
How to reduce that read or query time on the single node cluster?</p>