Secondary index impact on write performance

2012-08-04 Thread David McNelis
Morning, Was reading up on secondary indexes and on the Datastax post about them, it mentions the additional management overhead, and also that if you alter an existing column family, that data will be updated in the background. But how do secondary indexes affect write performance? If the

Re: Secondary index impact on write performance

2012-08-04 Thread Dave Brosius
There is a second (system managed) column family for each secondary index, so any write to a field that is indexed causes two writes, one to the main column family, and another to the index column family, where in this index column family the key is the value of the secondary column, and the

Re: Secondary index impact on write performance

2012-08-04 Thread David McNelis
Thanks. That was what I expected, but wanted to confirm. On Aug 4, 2012 11:24 AM, Dave Brosius dbros...@mebigfatguy.com wrote: There is a second (system managed) column family for each secondary index, so any write to a field that is indexed causes two writes, one to the main column family,