From cassandra-user-return-2824-apmail-incubator-cassandra-user-archive=incubator.apache.org@incubator.apache.org Mon Mar 01 21:51:00 2010 Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 37160 invoked from network); 1 Mar 2010 21:51:00 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 1 Mar 2010 21:51:00 -0000 Received: (qmail 30459 invoked by uid 500); 1 Mar 2010 21:50:58 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 30446 invoked by uid 500); 1 Mar 2010 21:50:58 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 30438 invoked by uid 99); 1 Mar 2010 21:50:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Mar 2010 21:50:58 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates 74.125.82.175 as permitted sender) Received: from [74.125.82.175] (HELO mail-wy0-f175.google.com) (74.125.82.175) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Mar 2010 21:50:50 +0000 Received: by wyf28 with SMTP id 28so1457264wyf.6 for ; Mon, 01 Mar 2010 13:50:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=AJLa4kY5K3aVYJgYaEvbdWXW7PkYxOoUhKHmim1aRKY=; b=Q7+VPWzGdWkSfNaCdTVwReI3fpI7eNiA+J7RnpkyHuegSotewjswOghRdgsnqJUgm8 1oXhi9/LZ0mC00F59tKHmU8MGfeospjBwtYe/dJwu4Y67zz/sOyneHbvH0iBXbtkTAB8 Q844fHp2QqBoThPKfRxJOJgcUPnLvmvdj5lBQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=mgzoS6vfj0gWLOQhriBxH+E6iAShjzv26hC/wBnccPEuFiyFX7ThvLIwjoYQo2XZWJ dhxR+FjFJagkReHJa9DvLJfVd9RI2euQMuyUBd+HBNshWMfMq46RCoElEEynkuS1AfXG B2xk+nZR29xDzFugNHS5S3b7aSXEPLHoE+G68= MIME-Version: 1.0 Received: by 10.216.89.84 with SMTP id b62mr3403731wef.226.1267480229179; Mon, 01 Mar 2010 13:50:29 -0800 (PST) In-Reply-To: <74f4d40b1003011343ma0dd64aha3d1f99ebd93ddc3@mail.gmail.com> References: <74f4d40b1003011050r640135dbya3739fcd226fd8b9@mail.gmail.com> <74f4d40b1003011342v16a2a2aoda9dfe738fcf7408@mail.gmail.com> <74f4d40b1003011343ma0dd64aha3d1f99ebd93ddc3@mail.gmail.com> From: Jonathan Ellis Date: Mon, 1 Mar 2010 15:50:09 -0600 Message-ID: Subject: Re: Storage format To: cassandra-user@incubator.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org If you are turning a row containing supercolumns each with lots of subcolumns, into "one row per supercolumn" with lots of regular columns each, then yes, that would be more efficient (unless your really do read all the subcolumns w/ each query anyway, in which case it doesn't matter). On Mon, Mar 1, 2010 at 3:43 PM, Erik Holstad wrote: > Sorry about that! > Continuing: > > And in that case when using rows as indexes instead of columns we only need > to read > that specific row and might be more efficient in that case than to read a > big row every > time? > > -- > Regards Erik >