Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of peterwnolan@gmail.com
 designates 209.85.161.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=gupMh6ExSrUFhTVT55haQQ/L1nKgElGtbXSd16WwthJogAqIkGr2iq5aQEYHv/jN1z
         HZxccmEAlgvTY9MZ+afnnoO0w8QHR45/Qsk1mKl8urtr8n0Wz4ctcG9S3WB4rK8+JslE
         hLAH2K5Ud3pqMAj73lafbZSdFiyZIx0CH9v4o=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=z7LUyCQmx5NPYsWK209CC4Yyg=Q@mail.gmail.com>
References: <BANLkTikXKOBg7V-M8BFEJbdiyHAPdruD_Q@mail.gmail.com>
	<64497E8E-7AEA-4E30-A44E-5AD285887150@challet.eu>
	<BANLkTikHEejT0H8asSS0kgSbM9bDcy9MVg@mail.gmail.com>
	<20110610100436.a3f9ab54.mk@cognitivedissonance.ca>
	<BANLkTi=z7LUyCQmx5NPYsWK209CC4Yyg=Q@mail.gmail.com>
Date: Fri, 10 Jun 2011 11:27:15 -0400
Message-ID: <BANLkTinY9K0mwp6f_b+e_0nmfuoE_q6PFA@mail.gmail.com>
Subject: Re: One view per "query"?
From: Peter Nolan <peterwnolan@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00235418701c53d88404a55d3486

--00235418701c53d88404a55d3486
Content-Type: text/plain; charset=ISO-8859-1

>
> in regards to '10 million documents'
>


> not necessarily.  Say you want to find a doc whose field of 'artist' is
> 'dylan'
>

you can create a view called byArtist whose code looks like the following.

function (doc) {

     if (doc.artist) {
         emit(doc.artist,otherStuffYouWantToKnow)
     }

}

then you can query this view with startKey='dylan' and endKey='dylan'
and receive those docs that only have the field of artist set to 'dylan'.
 then you can do some kind of filtering on the client side.

yes, you'll have to do a little copypasta for each field you're interested
in querying on.

Again, if you have more complicated search algorithms (like regexps and
whatnot) check out the filter functions from the changes feed.

out of curiosity, what kind of project are you working?  Cause i did a
little music app myself and would love to see code if you're willing to
share.

-good luck

-Pete

--00235418701c53d88404a55d3486--