Return-Path: Delivered-To: apmail-incubator-couchdb-user-archive@locus.apache.org Received: (qmail 61255 invoked from network); 3 Nov 2008 05:19:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Nov 2008 05:19:41 -0000 Received: (qmail 71480 invoked by uid 500); 3 Nov 2008 05:19:46 -0000 Delivered-To: apmail-incubator-couchdb-user-archive@incubator.apache.org Received: (qmail 71440 invoked by uid 500); 3 Nov 2008 05:19:46 -0000 Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: couchdb-user@incubator.apache.org Delivered-To: mailing list couchdb-user@incubator.apache.org Received: (qmail 71429 invoked by uid 99); 3 Nov 2008 05:19:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Nov 2008 21:19:46 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of paul.joseph.davis@gmail.com designates 74.125.92.147 as permitted sender) Received: from [74.125.92.147] (HELO qw-out-1920.google.com) (74.125.92.147) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Nov 2008 05:18:31 +0000 Received: by qw-out-1920.google.com with SMTP id 4so1108668qwk.54 for ; Sun, 02 Nov 2008 21:19:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=rf02FwJ/seT3xRb36rHfXLninPQ+LYO/y4l7NnMVKGw=; b=XJD5QwjRDstf2ij16nMdA7dgWqgSTEFBjJaijDgKDXh+gTrFM076sn8/4yedjOdTGt sSRyP3IIBoaF6eZrDCC1fmzx3QV4uCRctwBpSOXg224Bz7mqPBi2iKtW+VzHbweWX1V/ aqBSDhTgxigi//A/FuwaHRRe/nsErMIYpbLmc= 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=ey34Rp1vkgYt9DDDfpmRq1m5rtRgNH/jDH4FyXOoO2hO1BWlq7/YFd9DBGxf6Fv6AW c+SMGwxJbQ797oyOCABFsk0oHa/ZEi5NYmLh1dRLmgLo8HYDonfjW5zBq0MZU/fuAVdn rOycsd9LWPUPk7JEqQVAVYAcNK90MNyYt5x+8= Received: by 10.214.25.4 with SMTP id 4mr33893qay.145.1225689551933; Sun, 02 Nov 2008 21:19:11 -0800 (PST) Received: by 10.214.215.21 with HTTP; Sun, 2 Nov 2008 21:19:11 -0800 (PST) Message-ID: Date: Mon, 3 Nov 2008 00:19:11 -0500 From: "Paul Davis" To: couchdb-user@incubator.apache.org Subject: Re: Largest CouchDB dbs? In-Reply-To: <8C1EE3D1-D62F-4C6A-A859-196297E09C3D@apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <8C1EE3D1-D62F-4C6A-A859-196297E09C3D@apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Also on second reading of the email, make sure to leverage loading documents via _bulk_docs. When I load huge numbers of documents I tend to try and load a couple thousand at a time. If an update fails I fall back to a binary search to find the offending record. There's an open request for identifying the offending records. View updates are admittedly slower than we'd like. There's planned work on making this sort of thing parallelized to automagically fill out multi-node clusters. Last I remember this is a 'probably 1.0' feature though. On Sun, Nov 2, 2008 at 5:23 PM, Ask Bj=F8rn Hansen wrote: > What are the largest known production DBs in CouchDB? > > I'm loading ~3M documents into a database that'll be probably around 10GB > and then grow from there. So not very much data, but inserting and updat= ing > views is much slower than I expected (or thought they were in tests on > earlier versions, is that possible?) > > > > - ask >