Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of brking@gmail.com designates
 66.249.82.231 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=Qk9Bj82VQhSyDJOiu0DRNmubLga+aMjGXaYtASET/AgzA3XVVryJXOSMrOEm5XTXPg
         T8M6PTUJcrldb8FkgbaEW2BeC90nNLgpLUocJHUc8Pm8nJbUZIYDAoed4Vs7NMwtk6LA
         bTss7/jvG4WrVkc6WeqAwdjPiHXXivv58w6A8=
Message-ID: <888cd9180806201345k423a4dc8j64a881f351bd60bd@mail.gmail.com>
Date: Fri, 20 Jun 2008 16:45:39 -0400
From: "Brad King" <brking@gmail.com>
To: couchdb-user@incubator.apache.org
Subject: view index build time
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have about 350K documents in a database. typically around 5K each. I
created and saved a view which simply looks at one field in the
document. I called the view for the first time with a key that should
only match one document, and its been awaiting a response for about 45
minutes now.

{
   "sku": {
       "map": "function(doc) { emit(doc.entityobject.SKU, doc); }"
   }
}

Is this typical, or is there some optimizing to be done on either my
view or the server? I'm also running on a VM so this may have some
effects, but smaller databases seem to be performing pretty well.
Insert times to set this up were actually really good I thought, at
4000 to 5000 documents per minute running from my laptop.