Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of vanpelt@gmail.com designates
 209.85.198.239 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=wk7TYZtY4DKPRjeF8Qa/zlfFsIvFtc5lduJRifjXlFXiDnA2F4KCTXoAWz+EjYuesW
         8avzyWdDlF0g6KJC3kL2Uzyyz+h1h2oqDk/9xeQHnmPNjr4rgcOdB2gr0989SWo0021+
         8LEk9do8iKptFIqSxYaC2kETtaBpshuU5UAuw=
Message-ID: <9d5c45d10901071547s169d479akdc26c0f9fd6fc86f@mail.gmail.com>
Date: Wed, 7 Jan 2009 15:47:23 -0800
From: "Chris Van Pelt" <vanpelt@gmail.com>
To: user@couchdb.apache.org
Subject: Re: Slooooow views
In-Reply-To: <84F9A5A5-4EC3-489C-89A3-28DAE3B34FC9@apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <9d5c45d10901071449m23f634c4v4efc6af6b8d8f3c9@mail.gmail.com>
	 <84F9A5A5-4EC3-489C-89A3-28DAE3B34FC9@apache.org>

I was using R11B...  I'm installing R12B-5 now.  Should I expect an
amazing performance increase?

Filled with anticipation :)

On Wed, Jan 7, 2009 at 3:37 PM, Jan Lehnardt <jan@apache.org> wrote:
> Can you make sure you are running on Erlang R12B-4 or newer?
>
> Cheers
> Jan
> --
> On 7 Jan 2009, at 23:49, Chris Van Pelt wrote:
>
>> I'm pretty new to couch, and I'm wondering if there is a way to
>> improve the performance of my views.  My views are very slow during
>> generation, but also during simple queries.
>>
>> A request to one of my views after it is fully updated takes 2-4
>> seconds.  The view is rather complex, using compound keys and an
>> involved reduce step, but I assumed that didn't matter once the update
>> step was complete.  I have 10000 documents in my DB.
>>
>> The update step, after adding 11 documents, takes 23 seconds.
>>
>> Because I have a web server talking directly to couch, I can't afford
>> requests taking longer than a few seconds.  Ideally my requests would
>> be in the tenths of seconds.  How do people deal with this in the real
>> world?  I understand I can fire off view generation manually, but than
>> all other requests hang while the view is being generated.
>>
>> I've also been looking for a way to edit my views without taking down
>> my entire site for the 15 minutes it takes to regenerate the entire
>> index.  It seems plausible to keep the old index around for queries
>> while the new index is being created, no?
>>
>> Chris
>>
>
>