For example,each row represent a job record,it has fields like "user","site","CPUTime","datasize","JobType"...
The fields in CF is fixed,just like a table.The query like this "select CPUTime,User,site from CF(or tablename) where user=xxx and Jobtype=xxx"

Best regards

2013/3/24 cem <>

Could you provide some other details about your schema design and queries? It is very hard to tell anything.


On Sun, Mar 24, 2013 at 12:40 PM, dong.yajun <> wrote:

 I'd suggest you to take look at the difference between Nosql and RDMS.


On Sun, Mar 24, 2013 at 5:15 PM, Ÿ <> wrote:
I am new to Cassandra.I do some test on a single machine. I install Cassandra with a binary tarball distribution.
I create a CF to store the data that get from MySQL. The CF has the same fields as the table in MySQL. So it looks like a table. 
I do the same select from the CF in Cassandra and the table in MySQL,and I find the processing time of MySQL is better than Cassandra.
So,I wander what are the advantages of Cassandra compare MySQL and how to improve the performance of Cassandra.
Is this the right way to use Cassandra.

Ric Dong