Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 88623 invoked from network); 21 Feb 2011 14:57:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 21 Feb 2011 14:57:08 -0000 Received: (qmail 45195 invoked by uid 500); 21 Feb 2011 14:57:06 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 44991 invoked by uid 500); 21 Feb 2011 14:57:02 -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 44983 invoked by uid 99); 21 Feb 2011 14:57:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Feb 2011 14:57:01 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of izquierdo@strands.com designates 217.116.18.226 as permitted sender) Received: from [217.116.18.226] (HELO mail.strands.com) (217.116.18.226) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Feb 2011 14:56:53 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.strands.com (Postfix) with ESMTP id 9501524C2D5 for ; Mon, 21 Feb 2011 15:56:32 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at strands.com X-Spam-Score: -9.185 X-Spam-Level: Received: from mail.strands.com ([127.0.0.1]) by localhost (mail.strands.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id DeQITVwBbb9w for ; Mon, 21 Feb 2011 15:56:32 +0100 (CET) Received: from [192.168.1.130] (mad-acens [93.90.24.166]) (using SSLv3 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: izquierdo) by mail.strands.com (Postfix) with ESMTPSA id 44C8F19694F for ; Mon, 21 Feb 2011 15:56:32 +0100 (CET) Subject: millions of columns in a row vs millions of rows with one column From: =?ISO-8859-1?Q?H=E9ctor?= Izquierdo Seliva To: user Content-Type: text/plain; charset="UTF-8" Date: Mon, 21 Feb 2011 15:56:24 +0100 Message-ID: <1298300184.12020.150.camel@mierdi-laptop> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 7bit X-Old-Spam-Flag: NO X-Old-Spam-Status: No, score=-9.185 required=5.1 tests=[ALL_TRUSTED=-5.5, BAYES_00=-4, SARE_MILLIONSOF=0.315] autolearn=no Hi Everyone. I'm testing performance differences of millions of columns in a row vs millions of rows. So far it seems wide rows perform better in terms of reads, but there can be potentially hundreds of millions of columns in a row. Is this going to be a problem? Should I go with individual rows? I run 6 nodes with 7.2 and a RF=3. Thanks for your help!