Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 32273 invoked from network); 8 Apr 2011 14:54:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 8 Apr 2011 14:54:04 -0000 Received: (qmail 4417 invoked by uid 500); 8 Apr 2011 14:54:02 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 4394 invoked by uid 500); 8 Apr 2011 14:54: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 4386 invoked by uid 99); 8 Apr 2011 14:54:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Apr 2011 14:54:02 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of adi.pandit@gmail.com designates 209.85.213.172 as permitted sender) Received: from [209.85.213.172] (HELO mail-yx0-f172.google.com) (209.85.213.172) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Apr 2011 14:53:56 +0000 Received: by yxk30 with SMTP id 30so1727626yxk.31 for ; Fri, 08 Apr 2011 07:53:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=3GKRorcjByvTw2L6ZTBf6B3hJsKYcGWV43+PXe86F4A=; b=F/QsJ6O7IETXPpsteDwf6OaL1BUyZEOiFNLEfh5X64gpEkZHCVH29Cnmeh6RdwHUDq R80z/LZfGocP1rEQXPNoqgrnQyhmrBRILecerswmcvpHWobxrVOcizQxf4tYv6JIU+z4 onNuv5ctUAwsPoxMCiuUHNzLFEjBtcd0be+sM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=tuuE07Re2RbhRqQIZB7nL6TqxRqsHWXvbIZCivPgB2riIbFQJzGshYSlzH3Ani6JSB dUzEKjAoLwez4x9cMWIMT/LCcC+ocHDMOK6gGYK+xq4P3JU/iehrElu1bkjA9oWjdJxE fhBER/rAHQWfdKxSRk4ZWr8iCOdY6gmrF8fZE= MIME-Version: 1.0 Received: by 10.101.72.18 with SMTP id z18mr1656382ank.95.1302274415551; Fri, 08 Apr 2011 07:53:35 -0700 (PDT) Received: by 10.100.226.17 with HTTP; Fri, 8 Apr 2011 07:53:35 -0700 (PDT) Date: Fri, 8 Apr 2011 10:53:35 -0400 Message-ID: Subject: ballpark low cardinality range for secondary indexes From: Adi To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0016368e1dd1f0650104a06963fe --0016368e1dd1f0650104a06963fe Content-Type: text/plain; charset=ISO-8859-1 I am trying to decide whether to use secondary indexes or use an inverted index column family for a use case. Is there any suggested ballpark range for low cardinality for which secondary indexes are suitable. Meaning at what range should using a secondary index be ruled in or out: cardinality of tens, hundreds, thousands,millions? I am not looking for any tested numbers a general suggestion/best practice recommendation will suffice. Thanks. -Adi --0016368e1dd1f0650104a06963fe Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I am trying to decide whether to use secondary indexes or use an inverted i= ndex column family for a use case. Is there any suggested ballpark range fo= r low cardinality for which secondary indexes are suitable.
Meaning at w= hat range should=A0 using a secondary index be ruled in or out: cardinality= of tens, hundreds, thousands,millions?
I am not looking for any tested numbers a general suggestion/best practice = recommendation will suffice.

Thanks.

-Adi

--0016368e1dd1f0650104a06963fe--