Re: Very slow inserts

2013-03-05 Thread Aleksey Yeschenko
cqlsh COPY is not designed for inserting millions of rows fast. If you need to do that, you should write your own tool, maybe in Java (and batch your inserts). -- AY On Tuesday, March 5, 2013 at 16:38 PM, Pushkar Prasad wrote: > Hi, > > > I'm using Cassandra 1.2.1, and I am using COPY comm

Very slow inserts

2013-03-05 Thread Pushkar Prasad
Hi, I'm using Cassandra 1.2.1, and I am using COPY command to insert millions of rows. Each row is 100 bytes long. The issue is that the insertion happens rather slowly, at rate of 1500 rows per second. We have 3 node cluster with 50 GB disk space each, and 4 GB RAM each. Cassandra process is r