cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eax Melanhovich <m...@eax.me>
Subject A few stupid questions...
Date Tue, 26 May 2015 19:00:45 GMT
Hello.

I'm reading "Beginning Apache Cassandra Development" and there are a few
things I can't figure out.

First. Lets say I have a table (field1, field2, field3, field4), where
(field1, field2) is a primary key and field1 is partition key. There is
a secondary index for field3 column. Do I right understand that in this
case query like:

select ... from my_table where field1 = 123 and field3 > '...'; 

... would be quite efficient, i.e. request would be send only to one
node, not the whole cluster?

Second. Lets say there is some data that almost never changes but is
read all the time. E.g. information about smiles in social network. Or
current sessions. In this case would Cassandra cache "hot" data in
memtable? Or such data should be stored somewhere else, i.e. Redis or
Couchbase?

-- 
Best regards,
Eax Melanhovich
http://eax.me/

Mime
View raw message