MySQL Cluster (don't use FKs yet) or Redis (in-memory databases) sound more appropriate for data that churns a lot.
Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. cass_top: https://github.com/jamesbriggs/cassandra-top ________________________________ From: Robert Coli <rc...@eventbrite.com> To: "user@cassandra.apache.org" <user@cassandra.apache.org> Sent: Monday, September 29, 2014 5:01 PM Subject: Re: Indexes Fragmentation On Sun, Sep 28, 2014 at 9:49 AM, Arthur Zubarev <arthur.zuba...@aol.com> wrote: There are 200+ times more updates and 50x inserts than analytical loads. > >In Cassandra to just be able to query (in CQL) on a column I have to have an >index, the question is what tall the fragmentation coming from the frequent >updates and inserts has on a CF? Do I also need to manually defrug? > You have appeared to have just asked if maintaing indexes which have a high rate of change in a log structured database with immutable data files is likely to be more performant than maintaining them in a database with modify-in-place semantics. "No." =Rob
