Return-Path: Delivered-To: apmail-incubator-couchdb-user-archive@locus.apache.org Received: (qmail 72438 invoked from network); 1 Aug 2008 17:43:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Aug 2008 17:43:01 -0000 Received: (qmail 67570 invoked by uid 500); 1 Aug 2008 17:43:00 -0000 Delivered-To: apmail-incubator-couchdb-user-archive@incubator.apache.org Received: (qmail 67542 invoked by uid 500); 1 Aug 2008 17:42:59 -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 67531 invoked by uid 99); 1 Aug 2008 17:42:59 -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 10:42:59 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [83.97.50.139] (HELO jan.prima.de) (83.97.50.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Aug 2008 17:42:03 +0000 Received: from e178218145.adsl.alicedsl.de (e178218145.adsl.alicedsl.de [::ffff:85.178.218.145]) (AUTH: LOGIN jan, SSL: TLSv1/SSLv3,128bits,AES128-SHA) by jan.prima.de with esmtp; Fri, 01 Aug 2008 17:36:29 +0000 Message-Id: <46718627-30C2-422A-B118-947F39056565@apache.org> From: Jan Lehnardt To: couchdb-user@incubator.apache.org In-Reply-To: <4aa4f4d60808011006y7451ad7dnc4483f0c0d75f7e7@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v928.1) Subject: Re: Is it possible to evaluate a view on a 20.000 documents database? Date: Fri, 1 Aug 2008 19:36:28 +0200 References: <4aa4f4d60807311410m6077d984x83cb3b5d4e8c6f17@mail.gmail.com> <06C596D4-E5D1-4161-BFF1-D3A40FFB4627@gmail.com> <4aa4f4d60807311538h5a9c9d02k2dc507a0b566f34@mail.gmail.com> <20080801160848.GA12647@ginosko.ndrix.org> <4aa4f4d60808011006y7451ad7dnc4483f0c0d75f7e7@mail.gmail.com> X-Mailer: Apple Mail (2.928.1) X-Virus-Checked: Checked by ClamAV on apache.org On Aug 1, 2008, at 19:06, Demetrius Nunes wrote: > What would be the best way to try out new views and not suffer with > the long > computation times on this big dataset? Should I create a "development" > database with only a subset (say a couple of hundred documents) of > the data > and work there until I have all the views I want and the port those > to the > "real" big database? That would be an option. Possible the route I'd take. Cheers Jan -- > On Fri, Aug 1, 2008 at 1:42 PM, Jan Lehnardt wrote: > >> >> On Aug 1, 2008, at 18:08, Michael Hendricks wrote: >> >> 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. >>> >> >> also, the doc id is always automatically included, so emit(null, >> null); >> does >> the trick as well :) for pagination use docid_startkey & _endkey. >> >> Cheers >> Jan >> -- >> > > > > -- > ____________________________ > http://www.demetriusnunes.com