Re: Poor write performance with seconrady index

2012-04-17 Thread aaron morton
Secondary indexes require a read and a write (potentially two) for every update. Regular mutations are no look writes and are much faster. Just like in a RDBMS, it's more efficient to insert data and then create the index than to insert data with the index present. An alternative is to

Re: Poor write performance with seconrady index

2012-04-17 Thread Patrik Modesto
Hi Aaron, thanks for the reply. I suspected it might be the read-and-write that causes the slower updates. Regards, P. On Tue, Apr 17, 2012 at 11:52, aaron morton aa...@thelastpickle.com wrote: Secondary indexes require a read and a write (potentially two) for every update. Regular mutations