From user-return-21996-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu Nov 3 19:09:28 2011 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 2D5EB7EC6 for ; Thu, 3 Nov 2011 19:09:28 +0000 (UTC) Received: (qmail 86223 invoked by uid 500); 3 Nov 2011 19:09:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 86192 invoked by uid 500); 3 Nov 2011 19:09:26 -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 86184 invoked by uid 99); 3 Nov 2011 19:09:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Nov 2011 19:09:26 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of driftx@gmail.com designates 209.85.214.44 as permitted sender) Received: from [209.85.214.44] (HELO mail-bw0-f44.google.com) (209.85.214.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Nov 2011 19:09:18 +0000 Received: by bkbzv15 with SMTP id zv15so1223274bkb.31 for ; Thu, 03 Nov 2011 12:08:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; bh=SaL5lnjJTNMSUfzhjIDWCTIeKDyxDdkgzpcSSDz+XTI=; b=nTZ4b7+5GH+x7z51QMf+jtJfI+vOkdKQTyYblj15vNBbsV3we6SguDHg2ouzWOhOOX C6++QNOeEeGEn2HFspd9bNF3+x5PDH01M2NkpUfJ0qrUmWLGSV4mWKEa4v3fEXNHTU+q eRJWZbtamVN5HewqyLdlMKl8Jd32UIEOG2I1M= Received: by 10.204.154.151 with SMTP id o23mr9461908bkw.62.1320347338070; Thu, 03 Nov 2011 12:08:58 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.130.14 with HTTP; Thu, 3 Nov 2011 12:08:26 -0700 (PDT) In-Reply-To: References: From: Brandon Williams Date: Thu, 3 Nov 2011 14:08:26 -0500 Message-ID: Subject: Re: Retreiving column by names Vs by range, which is more performant ? To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org On Thu, Nov 3, 2011 at 2:05 PM, Ertio Lew wrote: > Retrieving=A0columns by names vs by range which is more performant , when= you > have the options to do both ? Assuming the columns have never been overwritten, range has a small advanta= ge. However, in the face of frequently updated (overwritten) columns, names will tear it up with https://issues.apache.org/jira/browse/CASSANDRA-2498 -Brandon