Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 11205 invoked from network); 16 Aug 2010 02:49:15 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 16 Aug 2010 02:49:15 -0000 Received: (qmail 5599 invoked by uid 500); 16 Aug 2010 02:49:13 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 5496 invoked by uid 500); 16 Aug 2010 02:49:12 -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 5488 invoked by uid 99); 16 Aug 2010 02:49:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Aug 2010 02:49:11 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [64.191.203.36] (HELO mail.digg.com) (64.191.203.36) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Aug 2010 02:49:03 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.digg.com (Postfix) with ESMTP id C2C92A85015 for ; Sun, 15 Aug 2010 19:48:42 -0700 (PDT) X-Virus-Scanned: amavisd-new at d242.digg.internal Received: from mail.digg.com ([127.0.0.1]) by localhost (mail.digg.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0K3PdMGRaHGC for ; Sun, 15 Aug 2010 19:48:42 -0700 (PDT) Received: from [10.2.16.222] (diggstage01.digg.com [64.191.203.34]) by mail.digg.com (Postfix) with ESMTP id 74594A84FF7 for ; Sun, 15 Aug 2010 19:48:42 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Apple Message framework v1077) Subject: Re: indexing rows ordered by int From: Chris Goffinet In-Reply-To: Date: Sun, 15 Aug 2010 19:48:42 -0700 Content-Transfer-Encoding: quoted-printable Message-Id: <4F3C3660-CB8B-47CA-B6E9-0361D8C9A782@chrisgoffinet.com> References: To: user@cassandra.apache.org X-Mailer: Apple Mail (2.1077) Digg is using redis for such a feature as well. We use it on the MyNews = - Top in 24 hours. Since we need timestamp ordering + sorting by how = many friends touch a story. -Chris On Aug 15, 2010, at 7:34 PM, Benjamin Black wrote: > http://code.google.com/p/redis/ >=20 > On Sat, Aug 14, 2010 at 11:51 PM, S Ahmed = wrote: >> For CF that I need to perform range scans on, I create separate CF = that have >> custom ordering. >> Say a CF holds comments on a story (like comments on a reddit or digg = story >> post) >> So if I need to order comments by votes, it seems I have to re-index = every >> time someone votes on a comment (or batch it every x minutes). >>=20 >>=20 >> Right now I think I have to pull all the comments into memory, then = sort by >> votes, then re-write the index. >> Are there any best-practises for this type of index?