Return-Path: Delivered-To: apmail-incubator-couchdb-user-archive@locus.apache.org Received: (qmail 15472 invoked from network); 1 Aug 2008 16:09:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Aug 2008 16:09:37 -0000 Received: (qmail 91201 invoked by uid 500); 1 Aug 2008 16:09:35 -0000 Delivered-To: apmail-incubator-couchdb-user-archive@incubator.apache.org Received: (qmail 91177 invoked by uid 500); 1 Aug 2008 16:09:35 -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 91165 invoked by uid 99); 1 Aug 2008 16:09:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Aug 2008 09:09:35 -0700 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [66.111.4.25] (HELO out1.smtp.messagingengine.com) (66.111.4.25) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Aug 2008 16:08:39 +0000 Received: from compute2.internal (compute2.internal [10.202.2.42]) by out1.messagingengine.com (Postfix) with ESMTP id 24E8714DC92 for ; Fri, 1 Aug 2008 12:09:05 -0400 (EDT) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by compute2.internal (MEProxy); Fri, 01 Aug 2008 12:09:05 -0400 X-Sasl-enc: IMshBfJr/JKLlFxtiWxxFZalWPyBF+k7Z/zTlQkWX13/ 1217606944 Received: from ndrix.org (unknown [166.230.131.80]) by mail.messagingengine.com (Postfix) with ESMTPSA id 308A2271B6 for ; Fri, 1 Aug 2008 12:09:03 -0400 (EDT) Date: Fri, 1 Aug 2008 10:08:48 -0600 From: Michael Hendricks To: couchdb-user@incubator.apache.org Subject: Re: Is it possible to evaluate a view on a 20.000 documents database? Message-ID: <20080801160848.GA12647@ginosko.ndrix.org> References: <4aa4f4d60807311410m6077d984x83cb3b5d4e8c6f17@mail.gmail.com> <06C596D4-E5D1-4161-BFF1-D3A40FFB4627@gmail.com> <4aa4f4d60807311538h5a9c9d02k2dc507a0b566f34@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4aa4f4d60807311538h5a9c9d02k2dc507a0b566f34@mail.gmail.com> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Checked: Checked by ClamAV on apache.org On Thu, Jul 31, 2008 at 07:38:03PM -0300, Demetrius Nunes wrote: > The view I am trying to create is really simple: > > function(doc) { > if > (doc.classe_id.match(/8a8090a20075ffba010075ffbed600028a8090a20075ffba010075ffbf7200c48a8090a20075ffba010075ffbf7200d9/)) > emit(doc.id, doc); > } You might try changing your emit() to emit(doc.id, null); I seem to recall some discussion on the mailing list that including the document in the emitted value (especially for large documents) can significantly affect view performance. -- Michael