Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of hknight555@gmail.com designates
 209.85.219.44 as permitted sender)
MIME-Version: 1.0
Date: Sun, 28 Jul 2013 14:22:56 -0300
Message-ID: 
 <CAMAefetJD8qgvYmJqPE-Ji2xTgWtv=eDjYNXcfb4DXgeDb9bPQ@mail.gmail.com>
Subject: CouchDB: Counting Total Occurrences of Unique Items
From: Hank Knight <hknight555@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

This returns exactly the results I want however I am concerned with performance.

There will only ever be a few dozen unique kinds of fruit however
there will tens of thousands of occurrences of each fruit.

Can I expect this to function well when there are tens of thousands
and even hundreds of thousands of documents?

For performance reasons, should anything be moved from the reduce
function to the map function or to an additional reduce function?

Here is my map function:
function(doc) {
  if (doc.fruit) emit("fruit",doc.fruit);
}

Here is my reduce function:
function (keys, values, rereduce) {
    var r = {};
    for(var f=0;f<values.length;f++) r[values[f]]?r[values[f]]++:r[values[f]]=1;
    return r;
}

Here is a link:
https://zurv3aqzm.iriscouch.com/_utils/database.html?fruit/_design/zzz3/_view/zzz3