incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Stevens <migh...@gmail.com>
Subject Re: Cassandra performance tuning...
Date Thu, 11 Jul 2013 13:33:53 GMT
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 <adanecito@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
>

Mime
View raw message