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 <adanec...@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 >
