Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 65089 invoked from network); 7 May 2010 22:03:52 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 7 May 2010 22:03:52 -0000 Received: (qmail 45721 invoked by uid 500); 7 May 2010 22:03:51 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 45674 invoked by uid 500); 7 May 2010 22:03:51 -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 45666 invoked by uid 99); 7 May 2010 22:03:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 May 2010 22:03:51 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of silent_vendetta@hotmail.com designates 65.55.90.170 as permitted sender) Received: from [65.55.90.170] (HELO snt0-omc3-s31.snt0.hotmail.com) (65.55.90.170) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 May 2010 22:03:44 +0000 Received: from SNT123-W50 ([65.55.90.137]) by snt0-omc3-s31.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 7 May 2010 15:03:23 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_979f2713-cae7-4939-9dbb-5f36ad30ebde_" X-Originating-IP: [71.227.235.190] From: Chris Hicks To: Subject: Best views performance Date: Fri, 7 May 2010 15:03:23 -0700 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 07 May 2010 22:03:23.0853 (UTC) FILETIME=[1CDCEFD0:01CAEE31] --_979f2713-cae7-4939-9dbb-5f36ad30ebde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If I have a DB of lets say 100K+ documents=2C with each document having 20 = fields=2C would it be more efficient to have a view that has indexed each d= ocument and simply run more complex queries over them or would it be better= to have a number of smaller views=2C each covering only a few fields=2C an= d running much simpler queries on each of these views for whatever data mig= ht be needed at that moment. As with most things the answer is probably "it= depends." If there is no easy answer could anyone tell me what the pros an= d cons are to each of these approaches? Chris Hicks =20 _________________________________________________________________ Hotmail has tools for the New Busy. Search=2C chat and e-mail from your inb= ox. http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326::T:WLMTAGL:O= N:WL:en-US:WM_HMP:042010_1= --_979f2713-cae7-4939-9dbb-5f36ad30ebde_--