Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 1235 invoked from network); 21 Mar 2011 18:06:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 21 Mar 2011 18:06:49 -0000 Received: (qmail 32462 invoked by uid 500); 21 Mar 2011 18:06:48 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 32419 invoked by uid 500); 21 Mar 2011 18:06:48 -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 32411 invoked by uid 99); 21 Mar 2011 18:06:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Mar 2011 18:06:48 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of paul.joseph.davis@gmail.com designates 209.85.216.52 as permitted sender) Received: from [209.85.216.52] (HELO mail-qw0-f52.google.com) (209.85.216.52) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Mar 2011 18:06:42 +0000 Received: by qwb8 with SMTP id 8so5319283qwb.11 for ; Mon, 21 Mar 2011 11:06:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type:content-transfer-encoding; bh=jPHyYOkKDmKQrmpEt01UFiaxdX2U5DnAnE/mY5/eU5Q=; b=MBj3Yc2lzLV2iQcf9OCRV+mbE7aXOD6kqzK65PKSfub2Ev9rfbe5g96Z/o6/RYflUr xgjTUEiSoTAaI38fOmbtxFU92CzabVnhdUxHXAa91RM4JR4H69xWMCVsbnuB6bLODuZ1 o9bTT+YEIP81DAk4rAj26XaRUWmy5K7wUWfcQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=A/IDP+T7C/rVNQaauGSFU/i3VbvvsA05F9+sBNJ0nhfXohRb/n60S1CKq/5J1+8LKX JkhzbNlMbwoJ7LowhqzXocsYslyx9nP6yqISH4zabQnMgZb848nTSB7yocGocZFPfw+f tRSSkuSbQAl7FXLOX1trYvlIRPFJ4CydDFsyI= Received: by 10.224.20.21 with SMTP id d21mr3605380qab.371.1300730781181; Mon, 21 Mar 2011 11:06:21 -0700 (PDT) MIME-Version: 1.0 Received: by 10.52.157.9 with HTTP; Mon, 21 Mar 2011 11:05:41 -0700 (PDT) In-Reply-To: References: From: Paul Davis Date: Mon, 21 Mar 2011 14:05:41 -0400 Message-ID: Subject: Re: blocking during view generation To: user@couchdb.apache.org Cc: Mark Hahn Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org On Mon, Mar 21, 2011 at 1:24 PM, Mark Hahn wrote: > I have noticed that all view queries are blocked for some time when I jus= t > change one view. =A0This seems like it is going to be a serious problem w= hen > my db grows. =A0Is there someway to avoid this in production? =A0I've nev= er seen > mysql or any other db block for any reason. > Also of note is that the updates are grouped at the _design/doc level, so if you want to update some subset of views individually you just need to split them amongst a set of _design/docs. There's also a scheme that lets you create a temporary _design/doc that can be moved over top of the existing version to have quickly updated views, but this approach requires you to have the disk capacity to have both versions built on disk simultaneously.