Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: local policy)
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=fgJbNyIiwnsTb9V+ZU4AVTXuCUHpTjupf2RMi/lSdv4
	UiY9O4djRc0ETvrVDms5rek5ME0rzWkiBgXuG/E3AMHgR1pwgHatZCNcKWmyGn9U
	BzrYcwl+8UTBV2+QP24duPsXUFy0hLd7sZJzXdchT4jDVhm1KkJO0DMIicRgxMgk
	=
Subject: Re: Column name size
References: <AANLkTi=jLRikYFuNabi44SxME0XWmpXraEtR+ZfWH0KJ@mail.gmail.com>
 <4D556229.8040602@gmail.com>
From: Aaron Morton <aaron@thelastpickle.com>
Content-Type: text/plain;
	charset=us-ascii
In-Reply-To: <4D556229.8040602@gmail.com>
Message-Id: <160571FD-A40E-43D4-8D3F-49A01C491CF2@thelastpickle.com>
Date: Mon, 14 Feb 2011 09:18:08 +1300
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (iPad Mail 8C148)

FWIW I would first try to reduce the number of columns, before reducing thei=
r name length. If you always pull back the same columns (e.g. User details) c=
onsider packing them in json dict and storing them in one column.

Aaron

On 12/02/2011, at 5:22 AM, Chris Burroughs <chris.burroughs@gmail.com> wrote=
:

> On 02/11/2011 05:06 AM, Patrik Modesto wrote:
>> Hi all!
>>=20
>> I'm thinking if size of a column name could matter for a large dataset
>> in Cassandra  (I mean lots of rows). For example what if I have a row
>> with 10 columns each has 10 bytes value and 10 bytes name. Do I have
>> half the row size just of the column names and the other half of the
>> data (not counting storage overhead)?  What if I have 10M of these
>> rows? Is there a difference? Should I use some 3bytes codes for a
>> column name to save memory/bandwidth?
>>=20
>> Thanks,
>> Patrik
>=20
> You are correct that you can for small row/column key values they key
> itself can represent a large proportion of the total size.  I think you
> will find the consensus on  this list is that trying to be clever with
> names is usually not worth the additional complexity.
>=20
> The right solution to this is
> https://issues.apache.org/jira/browse/CASSANDRA-47.