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 29155DE07 for ; Wed, 12 Sep 2012 21:42:59 +0000 (UTC) Received: (qmail 83430 invoked by uid 500); 12 Sep 2012 21:42:56 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 83408 invoked by uid 500); 12 Sep 2012 21:42:56 -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 83398 invoked by uid 99); 12 Sep 2012 21:42:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Sep 2012 21:42:56 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a92.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Sep 2012 21:42:51 +0000 Received: from homiemail-a92.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a92.g.dreamhost.com (Postfix) with ESMTP id 34F5F3DC06D for ; Wed, 12 Sep 2012 14:42:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :content-type:message-id:mime-version:subject:date:references:to :in-reply-to; s=thelastpickle.com; bh=eoDs1w1DkeI/AOUihR+nDLKXIa w=; b=LrhubJ1vLf1eubMg2GyKNGZBtO/HuU0fiBXHpmB5W4vDF/2NH3kS7+hhZN Snn6lwM2v0oMcF911YcHieJe/GUw02miXP/n/zJv0zmEXaNPViP2Q3UHNQBvPTOl XbIA2envyHVBs5yW9GHuEVQorsg80sbywRfY36K1ekaroqIFU= Received: from [192.168.2.77] (unknown [116.90.132.105]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a92.g.dreamhost.com (Postfix) with ESMTPSA id B1C903DC05B for ; Wed, 12 Sep 2012 14:42:29 -0700 (PDT) From: aaron morton Content-Type: multipart/alternative; boundary="Apple-Mail=_EB285F03-6E50-4B57-97F1-F36864FA3F1B" Message-Id: Mime-Version: 1.0 (Mac OS X Mail 6.0 \(1486\)) Subject: Re: Number of columns per row for Composite Primary Key CQL 3.0 Date: Thu, 13 Sep 2012 09:42:28 +1200 References: <92DC9EE9-3C7B-4F89-B058-4A5184D6EF7A@thelastpickle.com> To: user@cassandra.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1486) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_EB285F03-6E50-4B57-97F1-F36864FA3F1B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=GB2312 > What is "MM" stands for? million ? Yup.=20 No idea why I do that. cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:25 AM, Data Craftsman =C4=BE=BD=B3 = wrote: > Hi Aaron, >=20 > Thanks for the suggestion, as always. :) I'll read your slides = soon. >=20 > What is "MM" stands for? million ? >=20 > Thanks, > Charlie >=20 > On Mon, Sep 10, 2012 at 6:37 PM, aaron morton = wrote: >> In general wider rows take a bit longer to read, however different = access >> patterns have different performance. I did some tests here >> = http://www.slideshare.net/aaronmorton/cassandra-sf-2012-technical-deep-div= e-query-performance >> and http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/ >>=20 >> I would suggest 1MM cols is fine, if you get to 10MM cols per row you >> probably have gone too far. Remember the byte size of the row is also >> important; larger rows churn memory more and take longer to compact / >> repair. >>=20 >> Hope that helps. >>=20 >> ----------------- >> Aaron Morton >> Freelance Developer >> @aaronmorton >> http://www.thelastpickle.com >>=20 >> On 8/09/2012, at 11:05 AM, Data Craftsman =C4=BE=BD=B3 = >> wrote: >>=20 >> Hello experts. >>=20 >> Should I limit the number of rows per Composite Primary Key's leading >> column? >>=20 >> I think it falls into the same wide row good practice for number of >> columns per row for CQL 2.0, e.g. 10M or less. >>=20 >> Any comments will be appreciated. >>=20 >> -- >> Thanks, >>=20 >> Charlie (@mujiang) =C4=BE=BD=B3 >> =3D=3D=3D=3D=3D=3D=3D >> Data Architect Developer =BA=BA=CC=C6 =CC=EF=D4=B0=C4=C1=B8=E8DBA >> http://mujiang.blogspot.com --Apple-Mail=_EB285F03-6E50-4B57-97F1-F36864FA3F1B Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=GB2312 What is "MM" stands for? million = ?
Yup. 

No idea why I do = that.

cheers

http://www.thelastpickle.com

On 12/09/2012, at 11:25 AM, Data Craftsman =C4=BE=BD=B3 = <database.craftsman@gmail.com<= /a>> wrote:

Hi Aaron,

Thanks for the suggestion, as always. =  :)   I'll read your slides soon.

What is "MM" = stands for? million ?

Thanks,
Charlie

On Mon, Sep 10, = 2012 at 6:37 PM, aaron morton <aaron@thelastpickle.com> = wrote:
In general wider rows take a bit = longer to read, however different access
patterns have different = performance. I did some tests here
http://www.slideshare.net/aaronmorton/cassand= ra-sf-2012-technical-deep-dive-query-performance
and = http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/

I = would suggest 1MM cols is fine, if you get to 10MM cols per row = you
probably have gone too far. Remember the byte size of the row is = also
important; larger rows churn memory more and take longer to = compact /
repair.

Hope that = helps.

-----------------
Aaron Morton
Freelance = Developer
@aaronmorton
http://www.thelastpickle.com

On = 8/09/2012, at 11:05 AM, Data Craftsman =C4=BE=BD=B3 = <database.craftsman@gmail.com>
wrote:

Hello = experts.

Should I limit the number of rows per Composite Primary = Key's leading
column?

I think it falls into the same wide row = good practice for number of
columns per row for CQL 2.0, e.g. 10M or = less.

Any comments will be = appreciated.

--
Thanks,

Charlie (@mujiang) = =C4=BE=BD=B3
=3D=3D=3D=3D=3D=3D=3D
Data Architect Developer =BA=BA=CC= =C6 = =CC=EF=D4=B0=C4=C1=B8=E8DBA
http://mujiang.blogspot.com

= --Apple-Mail=_EB285F03-6E50-4B57-97F1-F36864FA3F1B--