Dear Sasha, I am currently thinking about using secondary index in the future. I have seen two pros : _Simplicity, it is "more simple" to query based on a second index than going for a first column then a second. _ "Consistency" : depending on where you store your inverted index, it may be unavailable to query because of a node down, or an error allows you to insert in the first column but then you crash and cannot insert into the inverted your inverse information. Because of that you cannot query and you have to periodically check the consistency of the data in the double column. That's what I am doing right now for my applications and making it simpler and more consistent would be great.
Remember : I don't know the details of the implementation, I take this principle as if it was perfectly working. But I am interested in experiences. Best regards, Victor K. http://www.voxnucleus.fr 2011/1/28 Sasha Dolgy <sdo...@gmail.com> > Thank you. So, after reading, I'm still unsure if this feature will > afford me a larger benefit when compared to an inverted index > solution. > > Has anyone done a pros / cons ? > > -sd > > > On Fri, Jan 28, 2011 at 3:22 PM, Jake Luciani <jak...@gmail.com> wrote: > > http://www.datastax.com/blog/whats-new-cassandra-07-secondary-indexes > > > > On Fri, Jan 28, 2011 at 7:15 AM, Sasha Dolgy <sasha.do...@gmail.com> > wrote: > >> > >> Hi there, > >> > >> Where can I find information regarding secondary indexes? Spent the > >> past 2 days looking for some good details. > >> > >> http://wiki.apache.org/cassandra/SecondaryIndexes doesn't yet exist, > >> althought it's referenced from > >> http://wiki.apache.org/cassandra/StorageConfiguration > >> > >> Trying to understand if this feature will afford me a larger benefit > >> when compared to an inverted index solution. > >> > >> Thanks in advance, > >> -sd > >> > >> -- > >> Sasha Dolgy > >> @sdolgy > >> sasha.do...@gmail.com >
