Hi, I am quite new to Cassandra and trying to evaluate its feasibility for our application. In our application, we need to insert roughly 300000 sensor data every 30 seconds (basically we need to store time-series data). I wrote a simple java code to insert 300000 random data every 30 seconds for 10 iterations, and measured the number of entries in the table after each insertion. But after iteration 8, (i.e. inserting 1500000 sensor data), the "select count(') ...) throws time-out exception and doesn't work anymore. I even tried to execute "select count(*)..." using Datastax DevCenter GUI, but I got same result.
I am sure that I have missed something or misunderstood how Cassandra works, but don't know really what? I do appreciate any hints. best, /Shahab