Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 62558 invoked from network); 7 Mar 2011 21:09:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Mar 2011 21:09:22 -0000 Received: (qmail 55654 invoked by uid 500); 7 Mar 2011 21:09:20 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 55620 invoked by uid 500); 7 Mar 2011 21:09:19 -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 55612 invoked by uid 99); 7 Mar 2011 21:09:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Mar 2011 21:09:19 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=MIME_QP_LONG_LINE,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-a83.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Mar 2011 21:09:14 +0000 Received: from homiemail-a83.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a83.g.dreamhost.com (Postfix) with ESMTP id 82B145E06C for ; Mon, 7 Mar 2011 13:08:53 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=subject :references:from:content-type:in-reply-to:message-id:date:to :content-transfer-encoding:mime-version; q=dns; s= thelastpickle.com; b=f+uKzlTlADZtGNaFccCTluxfiJ6Ln+R+ak7xjtwqKKA YqHFp03zZs9+9c33wFTNOfYWl47N9ucjdkVpaQ91NJFaIQJ5rLM7+C4P6jTWo+UN 1asxpneYZG62eR/nHDyP5RNHcwcesx2rDrHzJzBJP7tgqffDehCSQUNsIa+RNucg = DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h= subject:references:from:content-type:in-reply-to:message-id:date :to:content-transfer-encoding:mime-version; s=thelastpickle.com; bh=mxsYIS7wIzqrZ0W7Ka4EwyoNb6c=; b=uniis7hqwdHkySuyOMfLyoyP+yEV gadQfkVQXzGRVO8uOmCewvIH0KaO5nLy6THKK59jCwnmg6d2LXujbn+44fWUKD0k f/Jtajd4+rdFhafySUvGdh0W6HXOWnlo95wSdP0SK6R7f+X402gvcecmBAJj//QL /NuQbixishbNsLU= Received: from [115.189.226.153] (unknown [115.189.226.153]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a83.g.dreamhost.com (Postfix) with ESMTPSA id 0489D5E063 for ; Mon, 7 Mar 2011 13:08:52 -0800 (PST) Subject: Re: What would be a good strategy for Storing the large text contents like blog posts in Cassandra. References: <4D750062.3050109@cryptolog.com> From: Aaron Morton Content-Type: text/plain; charset=us-ascii X-Mailer: iPad Mail (8C148) In-Reply-To: <4D750062.3050109@cryptolog.com> Message-Id: <3EAB7790-53F0-495E-A551-3F3B7734F710@thelastpickle.com> Date: Tue, 8 Mar 2011 10:08:45 +1300 To: "user@cassandra.apache.org" Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (iPad Mail 8C148) You can fill your boots. So long as your boots have a capacity of 2 billion. Background ... http://wiki.apache.org/cassandra/LargeDataSetConsiderations http://wiki.apache.org/cassandra/CassandraLimitations http://www.pcworld.idg.com.au/article/373483/new_cassandra_can_pack_two_bill= ion_columns_into_row/ aaron On 8/03/2011, at 4:57 AM, Jean-Christophe Sirot wrote: > Hello, >=20 > On 03/06/2011 06:35 PM, Aditya Narayan wrote: >> Next, I also need to store the blogComments which I am planning to >> store all, in another single row. 1 comment per column. Thus the >> entire information about the a single comment like commentBody, >> commentor would be serialized(using google Protocol buffers) and >> stored in a single column, >=20 > Is there any limitation/issue in having a signle row with a lot of columns= ? For instance, can I have millions of columns in a single row? >=20 > --=20 > Jean-Christophe Sirot >=20