Re: Insert v/s Update performance

2013-04-02 Thread Jay Svc
sstable_size_in_mb and observed simillar behavior. > >> > >> Does compaction works differently for update v/s Insert? I belive all > keys goes to single SST. What other options I should look into? > >> > >> Thanks, > >> Jay > >> > >&

Re: Insert v/s Update performance

2013-03-31 Thread aaron morton
will constantly compact….well, that is my understanding. Have you tried >> STCS out at all? (ps. This is just from what I understand so take with a >> grain of salt). >> >> Also, there are some great tools in the nodetool tool as well so you can get >> nodetool compac

Re: Insert v/s Update performance

2013-03-29 Thread Jay Svc
t;> get nodetool compactionstats, etc. etc. and see how backlogged you are in >> pending tasks….how many pending? >> >> Later, >> Dean >> >> From: Jay Svc mailto:jaytechg...@gmail.com>> >> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.ap

Re: Insert v/s Update performance

2013-03-27 Thread aaron morton
tc. etc. and see how backlogged you are in pending > tasks….how many pending? > > Later, > Dean > > From: Jay Svc mailto:jaytechg...@gmail.com>> > Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mailto:user@cassandra.apache.o

Re: Insert v/s Update performance

2013-03-26 Thread Jay Svc
g<mailto:user@cassandra.apache.org>> > Date: Tuesday, March 26, 2013 6:08 PM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Subject: Re: Insert v/s Update performanc

Re: Insert v/s Update performance

2013-03-26 Thread Hiller, Dean
ache.org<mailto:user@cassandra.apache.org><mailto:user@cassandra.apache.org<mailto:user@cassandra.apache.org>>" mailto:user@cassandra.apache.org><mailto:user@cassandra.apache.org<mailto:user@cassandra.apache.org>>> Subject: Insert v/s Update performance Hi Te

Re: Insert v/s Update performance

2013-03-26 Thread Jay Svc
y, March 26, 2013 5:05 PM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Subject: Insert v/s Update performance > > Hi Team, > > I have this 3 node cluster. I am writi

Re: Insert v/s Update performance

2013-03-26 Thread Hiller, Dean
...@gmail.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Tuesday, March 26, 2013 5:05 PM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.

Insert v/s Update performance

2013-03-26 Thread Jay Svc
Hi Team, I have this 3 node cluster. I am writing data to these node at the rate of 2,000 records/second. What I observed that if I do inserts. (Means records for those keys does not exist, my column family has 0 records to start with) then I have better write performacne, low SSTable count, low p