I hope you can help me.
I have a cassandra setup with two nodes. On this I actually have one Keyspace with the replication factor 2 and one Column Family.
This column family contains <2.000 rows and each row has round about 200 Collumns (growing).
Inserting data is fine. Verry fast, verry coool!
Now my problem:
I'm trying to sth. like a scan over all collumns of one row. Therefor I use Java Hector and coded the following
SliceQuery<String,UUID,byte> query = HFactory.createSliceQuery("myKeyspace", StringSerializer.get(), TimeUUIDSerializer.get(), BytesArraySerializer.get());
query.setColumnFamily("myCf").setKey("someKey").setRange(null, null, false, 10000);
QueryResult<ColumnSlice<UUID, byte>> result = query.execute();
List<HColumn<UUID, byte>> columns = result.get().getColumns();
It seems that the query.execute() command takes several seconds to return (~10). This seems to be very slow for me. And it seems that the number of Collums is not the cause of this.
Does anyone has a hint for me?