insert slowdown with secondary indexes

2011-06-10 Thread jodylandreneau
Problem: I am attempting to compare a data model of SuperColumn family with a normal Column Family with Secondary Indexes. I did not have insert issues with the SuperColumn family. The problem I am having seems to be inserting into the Column Family with indexes. Seems to be very slow and getti

Re: insert slowdown with secondary indexes

2011-06-11 Thread Donal Zang
On 11/06/2011 02:27, jodylandren...@comcast.net wrote: I'm trying to understand why doing the inserts into a column family with indexes seems to jam things up and am wondering if there are any settings that I could tweak to help. It seems that the 4 node cluster should be able to handle 2 thre

Re: insert slowdown with secondary indexes

2011-06-12 Thread aaron morton
There are several possible issues here, to diagnose them would require some info on how fast you are writing and what CL level. Some thoughts http://wiki.apache.org/cassandra/FAQ#slows_down_after_lotso_inserts 32 bit machine and 2GV JVM is not ideal. A single HDD means the commit log and th