From user-return-12714-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Thu Sep 16 22:27:47 2010 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 76882 invoked from network); 16 Sep 2010 22:27:46 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 16 Sep 2010 22:27:46 -0000 Received: (qmail 80970 invoked by uid 500); 16 Sep 2010 22:27:45 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 80919 invoked by uid 500); 16 Sep 2010 22:27:45 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 80911 invoked by uid 99); 16 Sep 2010 22:27:44 -0000 Received: from Unknown (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Sep 2010 22:27:44 +0000 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.214.180] (HELO mail-iw0-f180.google.com) (209.85.214.180) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Sep 2010 22:27:23 +0000 Received: by iwn8 with SMTP id 8so2067110iwn.11 for ; Thu, 16 Sep 2010 15:27:01 -0700 (PDT) MIME-Version: 1.0 Received: by 10.231.167.130 with SMTP id q2mr3951760iby.163.1284676020883; Thu, 16 Sep 2010 15:27:00 -0700 (PDT) Received: by 10.231.185.141 with HTTP; Thu, 16 Sep 2010 15:27:00 -0700 (PDT) In-Reply-To: References: Date: Thu, 16 Sep 2010 18:27:00 -0400 Message-ID: Subject: Re: "IN" SQL Clause in Couch View From: Jarrod Roberson To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=0050450143dde05027049067f114 X-Virus-Checked: Checked by ClamAV on apache.org --0050450143dde05027049067f114 Content-Type: text/plain; charset=ISO-8859-1 On Wed, Sep 15, 2010 at 5:30 AM, Ido Ran wrote: > I don't know the keywords apriori so I can't create view for each keyword. > Also it sound like very complicated solution to what look like simple > problem. > > I've found this post > > http://www.vertigrated.com/blog/2010/04/where-clauses-like-selects-against-couchdb/ > on > how to create selective where. It is still pretty complex and he use both > view as well as List Function so I need to see how evently will handle List > Function - I know evently can retrieve a view but I don't know about List > Function. > > Thank you all for the answers, > Ido > > That has been susperceded by this article http://www.vertigrated.com/blog/2010/04/generic-ad-hoc-queries-in-couchdb/ And for my dataset which was a few hundred thousand entries it preformed in a manner that I never needed to replace it. That said, multi-views if accepted into the production branch would be a better solution. --0050450143dde05027049067f114--