incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francisco Nogueira Calmon Sobral <fsob...@igcorp.com.br>
Subject Slow retrieval using secondary indexes
Date Fri, 26 Apr 2013 12:27:52 GMT
Hi all!

We are using Cassandra 1.2.1 with a 8 node cluster running at Amazon. We started with 6 nodes
and added the 2 later. When performing some reads in Cassandra, we observed a high difference
between gets using the primary key and gets using secondary indexes:


[default@Sessions] get Users where mahoutUserid = 30127944399716352;
-------------------
RowKey: STQ0TTNII2LS211YYJI4GEV80M1SE8
=> (column=mahoutUserid, value=30127944399716352, timestamp=1366820944696000)

1 Row Returned.
Elapsed time: 3508 msec(s).

[default@Sessions] get Users['STQ0TTNII2LS211YYJI4GEV80M1SE8'];
=> (column=mahoutUserid, value=30127944399716352, timestamp=1366820944696000)
Returned 1 results.

Elapsed time: 3.06 msec(s).


In our model the secondary index in also unique, as the primary key is. Is it better, in this
case, to create another CF mapping the secondary index to the key?

Best regards,
Francisco Sobral.
Mime
View raw message