Thanks a lot. Regards, Shahab
On Thu, Aug 1, 2013 at 8:32 PM, Robert Coli <rc...@eventbrite.com> wrote: > On Thu, Aug 1, 2013 at 2:34 PM, Shahab Yunus <shahab.yu...@gmail.com>wrote: > >> Can you shed some more light (or point towards some other resource) that >> why you think built-in Secondary Indexes should not be used easily or >> without much consideration? Thanks. >> > > 1) Secondary indexes are more or less modeled like a manual pseudo > Secondary Index CF would be. > 2) Except they are more opaque than doing it yourself. For example you > cannot see information on them in nodetool cfstats. > 3) And there have been a steady trickle of bugs which relate to their > implementation, in many cases resulting in them not returning the data they > should. [1] > 4) These bugs would not apply to a manual pseudo Secondary Index CF. > 5) And the only benefits you get are the marginal convenience of querying > the secondary index instead of a second CF, and atomic synchronized update. > 6) Which most people do not actually need. > > tl;dr : "unless you need the atomic update property, just use a manual > pseudo secondary index CF" > > =Rob > > [1] https://issues.apache.org/jira/browse/CASSANDRA-4785 , > https://issues.apache.org/jira/browse/CASSANDRA-5540 , > https://issues.apache.org/jira/browse/CASSANDRA-2897 , etc. > >
