Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of vanpelt@gmail.com designates
 209.85.198.237 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type
         :content-transfer-encoding:content-disposition;
        b=jNyKRpMxMlIwjYz5D4UGaXNsoOODViaJyhamOH+ZfWZr6xfTOZ5dldtLNSNjNOcD6Y
         Y3aOeZFi0SqPmavpz9SGo7eL9vK4pL282YbzfjOK2n4ofiMGIlqbui80A3vNjYZyTSPV
         /4ereJEommIJ5aHvh7wRWNRqu+NJnjipTWdP8=
Message-ID: <9d5c45d10901071449m23f634c4v4efc6af6b8d8f3c9@mail.gmail.com>
Date: Wed, 7 Jan 2009 14:49:46 -0800
From: "Chris Van Pelt" <vanpelt@gmail.com>
To: user@couchdb.apache.org
Subject: Slooooow views
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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