Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 42563 invoked from network); 1 Apr 2009 19:30:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Apr 2009 19:30:46 -0000 Received: (qmail 34385 invoked by uid 500); 1 Apr 2009 19:30:45 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 34324 invoked by uid 500); 1 Apr 2009 19:30: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 34314 invoked by uid 99); 1 Apr 2009 19:30:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Apr 2009 19:30:45 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of paul.joseph.davis@gmail.com designates 209.85.132.249 as permitted sender) Received: from [209.85.132.249] (HELO an-out-0708.google.com) (209.85.132.249) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Apr 2009 19:30:39 +0000 Received: by an-out-0708.google.com with SMTP id b2so132768ana.5 for ; Wed, 01 Apr 2009 12:30:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=kvlc6/0U/Yt0xwkdzV8pgf4MKfOVzvYaQIbElLMhMro=; b=iV290g1um8c3891Jv4CRdc4OtJz69NDGN/nERoBFV47O4T/c43XS5FyAsidouSyfWb OS1V3LKPkAF8T1kUOmRHJ6J67TB7ziyzooVTAJGuS7yIOJcIqQU2PxC6PfZ0jTySzKeV lQNPtZ+FlxILLjZ6aulBlRKQ64+oXTTi0rc9s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=BTLqtHgHhfmbvwkfSiKAaFbjyM6flW4L7G8ZuT14UXgbjyVFWvfftyboMcWh+hoFKF L8UlkZrAj/OPrxBZZBKQ069WGGQDHMkwKwDuXImS48rLggyf5WnsPocnecxSAF3yPLRY YkauaLJtvEDAqt3qTyuE9Ss421ICrOjVOMyxs= MIME-Version: 1.0 Received: by 10.100.226.16 with SMTP id y16mr2357226ang.129.1238614218297; Wed, 01 Apr 2009 12:30:18 -0700 (PDT) In-Reply-To: <404793.89283.qm@web30607.mail.mud.yahoo.com> References: <404793.89283.qm@web30607.mail.mud.yahoo.com> Date: Wed, 1 Apr 2009 15:30:18 -0400 Message-ID: Subject: Re: Suggestions on View performance optimization/improvement From: Paul Davis To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org On Wed, Apr 1, 2009 at 3:23 PM, Manjunath Somashekhar wrote: > > hi All, > > Would like to thank you all for such fantastic participation. Got to lear= n a lot apart from the question i asked :). > > I did make a change as kowsik suggested - although aware of the include_d= ocs feature nvr thought it would make such a big difference. The results ar= e pretty amazing - the view generation completes in about 25 mins - just on= e execution. Will need to perform a few more runs before getting a good ave= rage time. > Wow, that's way beyond what I would've expected. Do please try and get some solid numbers on this. Perhaps we should start a wiki section to try and gather some number reports for reference? > Thanks a lot. Do let me know if any more optimizations can be done. > > Thanks > Manju > > > >