Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 531CE67F6 for ; Sat, 14 May 2011 22:34:43 +0000 (UTC) Received: (qmail 7730 invoked by uid 500); 14 May 2011 22:34:41 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 7706 invoked by uid 500); 14 May 2011 22:34:41 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 7698 invoked by uid 99); 14 May 2011 22:34:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 May 2011 22:34:41 +0000 X-ASF-Spam-Status: No, hits=3.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of xiaowei609@gmail.com designates 209.85.215.44 as permitted sender) Received: from [209.85.215.44] (HELO mail-ew0-f44.google.com) (209.85.215.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 May 2011 22:34:33 +0000 Received: by ewy19 with SMTP id 19so1240208ewy.31 for ; Sat, 14 May 2011 15:34:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=0ARLJTAqEOcAGh+Z6OlYK1o2/gzlnJEiWpnXRsX/2P8=; b=xdf/kRlZO7EtofHxgnqokYpAZJ9H3CSL+MOnLcAjugd6n3qC4xcYSUAG/5BR3nGbFS R6K2HhXCMAOfiUjsX/1u+4o0sFJ/4P4lBX+hz+JeZDQ1pUTAov4Ty7cyIxFdsBY/9Cu+ OKWETt8pRXQVf4OVMvPaEySJ+pyLqo0BFFAh4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=Hb1LV4Nb896GpZULLu6GgGyEg8oU+6CFsYQLDjlSSMIBkV9kussCDBHXybBjdSRt2N di8lF56Syd2mizdJt1p3fJ1kk08FxT6y+4stRdZ1C1smRJxwh2BO8GufaufXwj/ssSxd 6yLlPoOEufW7aJXN7ja+9ktZhuZEuO72wgsfU= MIME-Version: 1.0 Received: by 10.213.34.193 with SMTP id m1mr1180600ebd.6.1305412453164; Sat, 14 May 2011 15:34:13 -0700 (PDT) Received: by 10.213.10.131 with HTTP; Sat, 14 May 2011 15:34:13 -0700 (PDT) Date: Sat, 14 May 2011 18:34:13 -0400 Message-ID: Subject: insert and batch_insert From: Xiaowei Wang To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=000e0cd5f3028e684a04a3440567 X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd5f3028e684a04a3440567 Content-Type: text/plain; charset=ISO-8859-1 Hi, We use Cassandra 0.7.4 to do TPC-C data loading on ec2 nodes. The loading driver is written in pycassa. We test the loading speed on insert and batch_insert, but it seems no significant difference. I know Cassandra first write data to memory. But still confused why batch_insert does not quick than single row insert. We only batch 2000 or 3000 rows a time.. Thanks for your help! Best, Xiaowei --000e0cd5f3028e684a04a3440567 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

We use Cassandra 0.7.4 to do TPC-C data loading on ec2 nodes. Th= e loading driver is written in pycassa. We test the loading speed on insert= and batch_insert, but it seems no significant difference. I know Cassandra= first write data to memory. But still confused why batch_insert does not q= uick than single row insert. We only batch 2000 or 3000 rows a time..

Thanks for your help!

Best,
Xiaowei
--000e0cd5f3028e684a04a3440567--