Cassandra performance tuning...

[Tony Anecito <ad...@yahoo.com>]

Hi All,

I am trying to compare Cassandra to another relational database. I am getting around 2-3msec response time using Datastax driver, Java 1.7.0_05 64-bit jre and the other database is under 500 microseconds for the jdbc SQL preparedStatement execute.. One of the major differences is Cassandra uses text for the default primary key in the Column family and the SQL table I use int which is faster. Can the primary column family key data type be changed to a int? I also know Casandra uses varint for IntegerType and not sure that will be what I need but I will try it if I can change "key" column to that. If I try Int32Type for the primary key I suspect I will need to reload the data after that change.

I have looked at the default Java Options in the Cassandra bat file and they seem a good starting point but I am just starting to tune now that I can get Column Family caching to work.


Regards,
-Tony

Re: Cassandra performance tuning...

[Eric Stevens <mi...@gmail.com>]

You should be able to set the key_validation_class on the column family to
use a different data type for the row keys.  You may not be able to change
this for a CF with existing data without some troubles due to a mismatch of
data types; if that's a concern you'll have to create a separate CF and
migrate your data.


On Wed, Jul 10, 2013 at 2:20 PM, Tony Anecito <ad...@yahoo.com> wrote:

> Hi All,
>
> I am trying to compare Cassandra to another relational database. I am
> getting around 2-3msec response time using Datastax driver, Java 1.7.0_05
> 64-bit jre and the other database is under 500 microseconds for the jdbc
> SQL preparedStatement execute.. One of the major differences is Cassandra
> uses text for the default primary key in the Column family and the SQL
> table I use int which is faster. Can the primary column family key data
> type be changed to a int? I also know Casandra uses varint for IntegerType
> and not sure that will be what I need but I will try it if I can change
> "key" column to that. If I try Int32Type for the primary key I suspect I
> will need to reload the data after that change.
>
> I have looked at the default Java Options in the Cassandra bat file and
> they seem a good starting point but I am just starting to tune now that I
> can get Column Family caching to work.
>
> Regards,
> -Tony
>