Return-Path: 
 <cassandra-user-return-1130-apmail-incubator-cassandra-user-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org
Received: (qmail 74613 invoked from network); 6 Nov 2009 16:54:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 6 Nov 2009 16:54:54 -0000
Received: (qmail 92398 invoked by uid 500); 6 Nov 2009 16:54:53 -0000
Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org
Received: (qmail 92383 invoked by uid 500); 6 Nov 2009 16:54:53 -0000
Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:cassandra-user-help@incubator.apache.org>
List-Unsubscribe: <mailto:cassandra-user-unsubscribe@incubator.apache.org>
List-Post: <mailto:cassandra-user@incubator.apache.org>
List-Id: <cassandra-user.incubator.apache.org>
Reply-To: cassandra-user@incubator.apache.org
Delivered-To: mailing list cassandra-user@incubator.apache.org
Received: (qmail 92374 invoked by uid 99); 6 Nov 2009 16:54:53 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Nov 2009 16:54:53 +0000
X-ASF-Spam-Status: No, hits=-1.7 required=5.0
	tests=AWL,BAYES_00,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of richiesgr@gmail.com
 designates 72.14.220.158 as permitted sender)
Received: from [72.14.220.158] (HELO fg-out-1718.google.com) (72.14.220.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Nov 2009 16:54:51 +0000
Received: by fg-out-1718.google.com with SMTP id e21so612611fga.0
        for <cassandra-user@incubator.apache.org>;
 Fri, 06 Nov 2009 08:54:30 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:date:message-id:subject
         :from:to:content-type;
        bh=TrG7nAj0qztoTEbZiwwsoU1aYDZtSpaRBgZ7mM07fKw=;
        b=AIG1mAIZWkyA08Sue7A9rJVvOvxUV0UtUzq9EU6UXC+ZmS2KQEIm+FdtyRKV+wy6wQ
         0tPQvJ+why6tzgaM7WBXfb5M4VQxwezZqYsEsVWsnZ8RNdcDaOQ5x31HZdPtd9062kuG
         LP0NGBmBgq3o6UFoVuTiyG3qXKRpDZGjzTe9c=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=jxDoGQDF0wz96M3uCNroE9W/8DMoxWAHKbEK6fLIWLwHWn1v9NRnWKYI7W2wI9/eNw
         o4Mv6614I2R8GL/3L1FgcKAs5YDe0MlG1uNEQNKuWe1LZnbdlAZjLwP74BzJ/1POJNmx
         zz1WZKsG35e4QElwzY9BQVltVFBQkAhIJe7hk=
MIME-Version: 1.0
Received: by 10.86.159.37 with SMTP id h37mr5974579fge.79.1257526470411; Fri,
	06 Nov 2009 08:54:30 -0800 (PST)
Date: Fri, 6 Nov 2009 18:54:30 +0200
Message-ID: <468b21170911060854m15e280d3ubdf6892677532fee@mail.gmail.com>
Subject: Time to insert bulk data is very high comparing to database
From: Richard grossman <richiesgr@gmail.com>
To: cassandra-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=001485e60a0d9088e00477b6b221

--001485e60a0d9088e00477b6b221
Content-Type: text/plain; charset=ISO-8859-1

Hi,

We've started to use cassandra as a viable solution for distributed
database.
I've only define 1 column family simple as that :
     <ColumnFamily CompareWith="UTF8Type"
                      Name="channelShow"
                      FlushPeriodInMinutes="15"/>

The average time i get is ~680 rows/second. The actual performance for our
oracle db is ~1400 rows/second.
I know the test is not very accurate because the cassandra and oracle db
doesn't run on the same hardware but there is really a big difference.
Is there something to check why it's so slow ??

Thanks

Richard

--001485e60a0d9088e00477b6b221
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<br><br>We&#39;ve started to use cassandra as a viable =
solution for distributed database. <br>I&#39;ve only define 1 column family=
 simple as that : <br>=A0=A0=A0=A0 &lt;ColumnFamily CompareWith=3D&quot;UTF=
8Type&quot; <br>


=A0=A0=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 Name=3D&quot;channe=
lShow&quot;<br>=A0=A0=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 Flus=
hPeriodInMinutes=3D&quot;15&quot;/&gt;=A0=A0 <br><br>The average time i get=
 is ~680 rows/second. The actual performance for our oracle db is ~1400 row=
s/second.<br>


I know the test is not very accurate because the cassandra and oracle
db doesn&#39;t run on the same hardware but there is really a big
difference.<br>Is there something to check why it&#39;s so slow ??<br><br>T=
hanks<br><br>
Richard</div>

--001485e60a0d9088e00477b6b221--