From user-return-6675-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Sun Oct 04 16:28:33 2009 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 10722 invoked from network); 4 Oct 2009 16:28:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Oct 2009 16:28:33 -0000 Received: (qmail 32677 invoked by uid 500); 4 Oct 2009 16:28:32 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 32600 invoked by uid 500); 4 Oct 2009 16:28:32 -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 32590 invoked by uid 99); 4 Oct 2009 16:28:32 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Oct 2009 16:28:32 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of glenn@rempe.us designates 209.85.210.176 as permitted sender) Received: from [209.85.210.176] (HELO mail-yx0-f176.google.com) (209.85.210.176) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Oct 2009 16:28:22 +0000 Received: by yxe6 with SMTP id 6so3009407yxe.13 for ; Sun, 04 Oct 2009 09:27:00 -0700 (PDT) MIME-Version: 1.0 Received: by 10.91.27.6 with SMTP id e6mr3046028agj.27.1254673620182; Sun, 04 Oct 2009 09:27:00 -0700 (PDT) In-Reply-To: References: <6cfccb3d0910030910m678c9157o811a57e02ffbeff0@mail.gmail.com> <6cfccb3d0910031824q5d9362c2k7719b32a779e956f@mail.gmail.com> <1521F562-7878-423B-BEC3-FF2A1916DA0C@gmail.com> <6cfccb3d0910032307i1df64f79u437d5c803bff2c50@mail.gmail.com> <6cfccb3d0910032327h111e74bw401e13f04a4892c6@mail.gmail.com> From: Glenn Rempe Date: Sun, 4 Oct 2009 09:26:40 -0700 Message-ID: <6cfccb3d0910040926h738d7b23h650f4e012ae578de@mail.gmail.com> Subject: Re: Timeout Error when trying to access views + Indexing problems To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=001485f912a870a79a04751e776b X-Virus-Checked: Checked by ClamAV on apache.org --001485f912a870a79a04751e776b Content-Type: text/plain; charset=UTF-8 BTW. That was a magic trick Chris. Thank you. Bulk saves of 1000 docs went from almost 1 minute to less than 2 seconds the moment I changed that value in the futon config interface. Is there a reason that is not the default setting? Thanks! Glenn > The next remedy here is to try one of the new uuid formats available in > 0.10 > > [uuids] > algorithm = sequential > > in your local ini should do it. > > this will help the btree to require less disk seeks to load the path > to each updated node, as sequential ids are more likely to be in FS > cache. > > I'm assuming your bulk saves are mostly new docs. > > Chris > > > -- > Chris Anderson > http://jchrisa.net > http://couch.io > --001485f912a870a79a04751e776b--