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/
