Re: Frequent updates of freshly written columns

2011-02-18 Thread Sylvain Lebresne
On Fri, Feb 18, 2011 at 6:19 PM, Aklin_81 wrote: > Sylvain, > I also need to store data that is frequently updated, same column > being updated several times during each user session, at each action > by user, But, this data is not very fresh and hence when I update this > column frequently, ther

Re: Frequent updates of freshly written columns

2011-02-18 Thread Aklin_81
Sylvain, I also need to store data that is frequently updated, same column being updated several times during each user session, at each action by user, But, this data is not very fresh and hence when I update this column frequently, there would be many versions of the same column in several sst fi

Re: Frequent updates of freshly written columns

2011-02-18 Thread James Churchman
ok great, thanks for the exact clarification On 18 Feb 2011, at 14:11, Aklin_81 wrote: > Compaction does not 'mutate' the sst files, it 'merges' several sst files > into one with new indexes, merged data rows & deleting tombstones. Thus you > reclaim your disk space. > > > On Fri, Feb 18, 201

Re: Frequent updates of freshly written columns

2011-02-18 Thread Aklin_81
Compaction does not 'mutate' the sst files, it 'merges' several sst files into one with new indexes, merged data rows & deleting tombstones. Thus you reclaim your disk space. On Fri, Feb 18, 2011 at 7:34 PM, James Churchman wrote: > but a compaction will mutate the sstables and reclaim the > spa

Re: Frequent updates of freshly written columns

2011-02-18 Thread James Churchman
but a compaction will mutate the sstables and reclaim the space (eventually) ? james On 18 Feb 2011, at 08:36, Sylvain Lebresne wrote: > On Fri, Feb 18, 2011 at 8:14 AM, Aklin_81 wrote: > Are the very freshly written columns to a row in memtables, efficiently > updated/overwritten by edited

Re: Frequent updates of freshly written columns

2011-02-18 Thread Sylvain Lebresne
On Fri, Feb 18, 2011 at 8:14 AM, Aklin_81 wrote: > Are the very freshly written columns to a row in memtables, efficiently > updated/overwritten by edited/new column values. > > After flushing of memtable, are those(edited + unedited ones) columns > stored together on disk (in same blocks!?) as i

Frequent updates of freshly written columns

2011-02-17 Thread Aklin_81
Are the very freshly written columns to a row in memtables, efficiently updated/overwritten by edited/new column values. After flushing of memtable, are those(edited + unedited ones) columns stored together on disk (in same blocks!?) as if they were written in one single operation or same time ??