Support Forums : DataStax

DataStax Support Forums » Apache Cassandra

Cassandra Read & Write Performance Matrix

(3 posts) (3 voices)

Started 1 year ago by
Latest reply from
This topic is not a support question

Tags:

Anonymous
Unregistered

hi all,

i am new to Cassandra
currently i am configured Cassandra 0.8.6 with single node in a unix server.
setting Cassandra JVM memory 512 and max 1024 and remaining as usual default settings.

i had inserted some sample data with 3 columns around 100 rows.
i checked that it takes around 2900 milliseconds for reading.

can any one tell what should be the read and write time with a single node cluster that Cassandra Specs says.
As in other RDBMS idle read and write should not take more than 50 milli seconds.

what are the things in need to cross check to improve my Cassandra Performance?

we are currently evaluating Cassandra for our data storage.

Thanks in advance

Posted 1 year ago #
thobbs
Administrator

What client are you using to do the read? What are you reading (one row, all 100 rows)? How are you measuring how long it takes?

Posted 1 year ago #
Anonymous
Unregistered

I am doing a comparison test between Cassandra and MS SQL. I have only one table/column family with 10 columns in it. I am trying to calculate the transaction per second Cassandra and MS SQL execute. While writing the data Cassandra process 5000 - 7000 transactions per second and MS SQL 70 - 90 transactions per second.

While reading the data Cassandra only process 500 - 700 transactions per second and MS SQL 3000 - 6000 transactions per second which is unexpected for me. I was expecting Cassandra to be faster than MS SQL both in case of reading and writing.

In case of Cassandra, I have 3 nodes cluster running remotly and MS SQL also running remotly. You can find the code below. I am using the same code for MS SQL and Cassandra

for(int i=0;i<BenchmarkConfig.insertData;i++)

{

orderId = Generate Radom ID;

rs = statement.executeQuery("Select * From ABC where KEY = "+orderId);

}

Can you please help me out why reading is that much slow in Cassandra ? To save the time to investigate I am using Random Partitioner for equal distribution and incase of reading, I have not specified any consistency level by default which is 1.

Posted 12 months ago #

RSS feed for this topic