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 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 running with > max heap size of 1 GB. We are storing commit logs and data files on the same > disk. What could be the cause of this behaviour? Any help would be > appreciated. > > > Thanks > > Pushkar