Return-Path: Delivered-To: apmail-incubator-couchdb-user-archive@locus.apache.org Received: (qmail 92840 invoked from network); 25 Sep 2008 18:27:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Sep 2008 18:27:14 -0000 Received: (qmail 72737 invoked by uid 500); 25 Sep 2008 18:27:11 -0000 Delivered-To: apmail-incubator-couchdb-user-archive@incubator.apache.org Received: (qmail 72703 invoked by uid 500); 25 Sep 2008 18:27:11 -0000 Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: couchdb-user@incubator.apache.org Delivered-To: mailing list couchdb-user@incubator.apache.org Received: (qmail 72692 invoked by uid 99); 25 Sep 2008 18:27:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Sep 2008 11:27:11 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: unknown (athena.apache.org: error in processing during lookup of jaap@brightin.nl) Received: from [209.85.217.19] (HELO mail-gx0-f19.google.com) (209.85.217.19) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Sep 2008 18:26:10 +0000 Received: by gxk12 with SMTP id 12so7688882gxk.12 for ; Thu, 25 Sep 2008 11:25:42 -0700 (PDT) Received: by 10.100.198.13 with SMTP id v13mr84613anf.107.1222367141924; Thu, 25 Sep 2008 11:25:41 -0700 (PDT) Received: by 10.100.154.4 with HTTP; Thu, 25 Sep 2008 11:25:41 -0700 (PDT) Message-ID: Date: Thu, 25 Sep 2008 20:25:41 +0200 From: "Jaap van der Plas" To: couchdb-user@incubator.apache.org Subject: Multiple filters on a large data set MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org Greetings, We like to build a database with approx. 50.000 documents. Every document has at least about 10 fields. We think CouchDB would be nice solution because there's a big variety of documents (like different fields). We intend to use this for an online catelog. We like end users to be able to search with multiple fields (like filters). Any combination of fields should be possible. 1. Is this possible to do this without creating temp_views for every query? 2. If not, is using temp_views viable performance wise on this sort of dataset. TIA