Return-Path: 
 <user-return-14584-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: (qmail 61666 invoked from network); 14 Mar 2011 20:39:08 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 14 Mar 2011 20:39:08 -0000
Received: (qmail 24424 invoked by uid 500); 14 Mar 2011 20:39:05 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 24401 invoked by uid 500); 14 Mar 2011 20:39:05 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 24393 invoked by uid 99); 14 Mar 2011 20:39:05 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Mar 2011 20:39:05 +0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [209.85.218.44] (HELO mail-yi0-f44.google.com) (209.85.218.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Mar 2011 20:39:00 +0000
Received: by yic13 with SMTP id 13so2860117yic.31
        for <user@cassandra.apache.org>; Mon, 14 Mar 2011 13:38:38 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.90.131.10 with SMTP id e10mr3703553agd.96.1300135118187; Mon,
 14 Mar 2011 13:38:38 -0700 (PDT)
Received: by 10.90.93.17 with HTTP; Mon, 14 Mar 2011 13:38:38 -0700 (PDT)
In-Reply-To: <AANLkTi=wSwFpbe1OmFB2DUeSP5+az2NzZtN1qhU6Vp-L@mail.gmail.com>
References: <AANLkTinbgJ5zov251TseLm57AdmqUzBp3rsAVd8-GQqg@mail.gmail.com>
	<AANLkTimis0RWhYrEqkbNyaRQA2qSr1av2GO7wB=BS==v@mail.gmail.com>
	<AANLkTi=wSwFpbe1OmFB2DUeSP5+az2NzZtN1qhU6Vp-L@mail.gmail.com>
Date: Mon, 14 Mar 2011 15:38:38 -0500
Message-ID: <AANLkTimcz9PQObKET=7UyAT57QGuf8cneOdFoTnVmWca@mail.gmail.com>
Subject: Re: Write speed roughly 1/10 of expected.
From: Steven Liu <steven@datafeedfile.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=00163628426ae12ba6049e774b15
X-Virus-Checked: Checked by ClamAV on apache.org

--00163628426ae12ba6049e774b15
Content-Type: text/plain; charset=ISO-8859-1

Re: Mr. Schuller,

The test documents are very small (a few lines of text each). Test data
model is standard CF with each document correponding to a row containing
9-12 columns. We are using a single client for sequential batch_insert
(probably maps to batch mutate in phpcassa), so it is very possible that
that's the bottleneck.

Re: Mr. Hobbs,

Did you mean "which has the benefit of THRIFT-638, while 0.7.a.2 does not"
(instead of 0.7.a.3)? 0.7.a.3 was the latest version of phpcassa we could
find on github. We installed 0.7.a.3 with its C extension and didn't see an
improvement. Is there a newer version with THRIFT-638 fix?

Steve


On Fri, Mar 11, 2011 at 4:55 PM, Tyler Hobbs <tyler@datastax.com> wrote:

> (I have no idea how fast phpcassa is.)
>>
>
> The current master branch (which has the benefit of THRIFT-638<https://issues.apache.org/jira/browse/THRIFT-638>,
> while 0.7.a.3 does not) can insert about 3k individual rows a second against
> a local Cassandra instance.
>
> --
> Tyler Hobbs
> Software Engineer, DataStax <http://datastax.com/>
> Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
> Python client library
>
>

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

Re: Mr. Schuller,<br><br>The test documents are very small (a few lines of =
text each). Test data model is standard CF with each document correponding =
to a row containing 9-12 columns. We are using a single client for sequenti=
al batch_insert (probably maps to batch mutate in phpcassa), so it is very =
possible that that&#39;s the bottleneck.<br>
<br>Re: Mr. Hobbs,<br><br>Did you mean &quot;which has the benefit of THRIF=
T-638, while 0.7.a.2 does=20
not&quot; (instead of 0.7.a.3)? 0.7.a.3 was the latest version of phpcassa =
we
 could find on github. We installed 0.7.a.3 with its C extension and didn&#=
39;t see an improvement. Is there a newer version with THRIFT-638 fix?<br><=
br>Steve<br><br><br><div class=3D"gmail_quote">On Fri, Mar 11, 2011 at 4:55=
 PM, Tyler Hobbs <span dir=3D"ltr">&lt;<a href=3D"mailto:tyler@datastax.com=
">tyler@datastax.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class=3D"im"=
><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"marg=
in: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-l=
eft: 1ex;">

(I have no idea how fast phpcassa is.)<br></blockquote></div><br></div>The =
current master branch (which has the benefit of=A0<a href=3D"https://issues=
.apache.org/jira/browse/THRIFT-638" target=3D"_blank">THRIFT-638</a>, while=
 0.7.a.3 does not) can insert about 3k individual rows a second against a l=
ocal Cassandra instance.<br>
<font color=3D"#888888">
<br>-- <br><font color=3D"#888888">Tyler Hobbs<span></span><br>
Software Engineer, <a href=3D"http://datastax.com/" target=3D"_blank">DataS=
tax</a><br>Maintainer of the <a href=3D"http://github.com/pycassa/pycassa" =
target=3D"_blank">pycassa</a> Cassandra Python client library<br></font><br=
>
</font></blockquote></div><br><div style=3D"visibility: hidden; left: -5000=
px;" id=3D"avg_ls_inline_popup"></div><style type=3D"text/css">#avg_ls_inli=
ne_popup{position: absolute;z-index: 9999;padding: 0px 0px;margin-left: 0px=
;margin-top: 0px;overflow: hidden;word-wrap: break-word;color: black;font-s=
ize: 10px;text-align: left;line-height: 130%;}</style>

--00163628426ae12ba6049e774b15--