Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 75127 invoked from network); 16 Oct 2010 06:42:54 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 16 Oct 2010 06:42:54 -0000 Received: (qmail 92649 invoked by uid 500); 16 Oct 2010 06:42:53 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 92320 invoked by uid 500); 16 Oct 2010 06:42:50 -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 92312 invoked by uid 99); 16 Oct 2010 06:42:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Oct 2010 06:42:49 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of james.jackson@cern.ch designates 137.138.144.177 as permitted sender) Received: from [137.138.144.177] (HELO CERNMX30.cern.ch) (137.138.144.177) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Oct 2010 06:42:39 +0000 Received: from CERNFE22.cern.ch (137.138.144.151) by cernmxgwlb2.cern.ch (137.138.144.177) with Microsoft SMTP Server (TLS) id 14.1.218.12; Sat, 16 Oct 2010 08:42:19 +0200 Received: from hepmbp3.home (86.138.108.95) by smtp.cern.ch (137.138.144.172) with Microsoft SMTP Server (TLS) id 14.1.218.12; Sat, 16 Oct 2010 08:42:19 +0200 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 (Apple Message framework v1078) Subject: Re: Volume Test - 2 million documents From: James Jackson In-Reply-To: Date: Sat, 16 Oct 2010 07:42:17 +0100 Content-Transfer-Encoding: quoted-printable Message-ID: <8F43C839-88BD-4F5D-BF05-554B52EC9CB0@cern.ch> References: <3954CD52-F9D4-4172-9301-A37B328D4687@thisonejustforme.com> To: X-Mailer: Apple Mail (2.1078) X-Originating-IP: [86.138.108.95] Keywords: CERN SpamKiller Note: -50 X-Virus-Checked: Checked by ClamAV on apache.org Hi, > Maybe experiment with doing batches of inserts followed by a limit=3D0 > view query to refresh the index.=20 We do this for all our inserts. It really does make a big difference - = if I just bulk insert when stress-testing without refreshing the views, = my laptop grinds to a halt. However, if I refresh the view after a bulk = insert, everything's hunky-dory. Regards, James.=