Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread Praveen Baratam
I understand that there will be contention regarding which *n* columns are the current *n* columns but as mentioned previously the goal is to limit the accumulation of data as in our use-case some row keys can receive fairly heavy inserts. For people requiring precise set of current columns that fe

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread aaron morton
During compaction, both automatic / minor and manual / major. The performance drop is having a lot of expired columns that have not been purged by compaction as they must be read and discarded during reads. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thel

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread R. Verlangen
@Aaron: Small side question, when do columns with a past TTL get removed? On a repair, (minor) compaction, or .. ? Does it have a performance drop if that's happening? 2012/1/2 aaron morton > Even if you had compaction enforcing a limit on the number of columns in a > row, there would still be i

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread aaron morton
Even if you had compaction enforcing a limit on the number of columns in a row, there would still be issues with concurrent writes at the same time and with read-repair. i.e. node a says the this is the first n columns but node b says something else, you only know who is correct at read time. H