> "select CPUTime,User,site from CF(or tablename) where user=xxx and 
> Jobtype=xxx"
Even thought cassandra has tables and looks like a RDBMS it's not. 
Queries with multiple secondary index clauses will not perform as well as those 
with none. 

 There is plenty of documentation here http://www.datastax.com/docs , start 
with the help on data modelling to get an idea of how Cassandra is different. 

Cheers

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 25/03/2013, at 4:32 AM, Derek Williams <de...@fyrie.net> wrote:

> Biggest advantage of Cassandra is it's ability to scale linearly as more 
> nodes are added and it's ability to handle node failures.
> 
> Also to get the maximum performance from Cassandra you need to be making 
> multiple requests in parallel.
> 
> 
> On Sun, Mar 24, 2013 at 3:15 AM, 张刚 <zhang.i...@gmail.com> wrote:
> Hello,
> 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.
> 
> 
> 
> 
> -- 
> Derek Williams

Reply via email to