From user-return-5964-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Wed Aug 12 20:36:47 2009
Return-Path: <user-return-5964-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org>
Delivered-To: apmail-couchdb-user-archive@www.apache.org
Received: (qmail 83794 invoked from network); 12 Aug 2009 20:36:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 12 Aug 2009 20:36:47 -0000
Received: (qmail 66100 invoked by uid 500); 12 Aug 2009 20:36:53 -0000
Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org
Received: (qmail 66008 invoked by uid 500); 12 Aug 2009 20:36:53 -0000
Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@couchdb.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@couchdb.apache.org>
List-Post: <mailto:user@couchdb.apache.org>
List-Id: <user.couchdb.apache.org>
Reply-To: user@couchdb.apache.org
Delivered-To: mailing list user@couchdb.apache.org
Received: (qmail 65998 invoked by uid 99); 12 Aug 2009 20:36:53 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Aug 2009 20:36:53 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of b.candler@pobox.com designates 64.74.157.62 as permitted sender)
Received: from [64.74.157.62] (HELO sasl.smtp.pobox.com) (64.74.157.62)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Aug 2009 20:36:43 +0000
Received: from localhost.localdomain (unknown [127.0.0.1])
	by a-pb-sasl-sd.pobox.com (Postfix) with ESMTP id 12A5627105;
	Wed, 12 Aug 2009 16:36:21 -0400 (EDT)
Received: from mappit (unknown [80.45.95.114]) (using TLSv1 with cipher
 AES256-SHA (256/256 bits)) (No client certificate requested) by
 a-pb-sasl-sd.pobox.com (Postfix) with ESMTPSA id 8019E27104; Wed, 12 Aug 2009
 16:36:19 -0400 (EDT)
Received: from brian by mappit with local (Exim 4.69) (envelope-from
 <b.candler@pobox.com>) id 1MbKYT-0001kp-LO; Wed, 12 Aug 2009 21:36:17 +0100
Date: Wed, 12 Aug 2009 21:36:17 +0100
From: Brian Candler <B.Candler@pobox.com>
To: Tommy Chheng <tommy.chheng@gmail.com>
Cc: user@couchdb.apache.org
Subject: Re: couchdb server connection refused error
Message-ID: <20090812203617.GA6696@uk.tiscali.com>
References: <880A5824-EB36-4263-AB38-3C4A80DD5515@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <880A5824-EB36-4263-AB38-3C4A80DD5515@gmail.com>
User-Agent: Mutt/1.5.17+20080114 (2008-01-14)
X-Pobox-Relay-ID:
 CB614ABA-877F-11DE-943D-AEF1826986A2-28021239!a-pb-sasl-sd.pobox.com
X-Virus-Checked: Checked by ClamAV on apache.org

On Mon, Aug 10, 2009 at 01:31:59PM -0700, Tommy Chheng wrote:
> NsfGrant.all will make one query(per paginated result) but I make  
> another query PER document to get a document's word count list(via a  
> view) in the NsfGrantSimilarity.compute_and_store method.  so it will be 
> trying to do 30k separate requests.

Then you will speed up your application tons by doing this in batches using
a multi-key fetch with POST :-)

Cheers,

Brian.