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 jchris@gmail.com designates
 72.14.220.157 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=k1RBdkF1plwFp76ESmUsZ4nYDq/p6bw8CUF8G9FFHhOLGLK8GJCdjwgMXgc4n+MxHAp8Mgkxd11yx47aczTay2+XDbhrLtyiYutSzSrKDdlPTPECcNUUDhGzafBD2zjW7YGVW+MV8a5Yt3upT2xpN38LrA4/YEhNUifHUizdOKw=
Message-ID: <e282921e0804252302m486ba5f4mc913ddf15c9601e7@mail.gmail.com>
Date: Fri, 25 Apr 2008 23:02:12 -0700
From: "Chris Anderson" <jchris@mfdz.com>
Sender: jchris@gmail.com
To: couchdb-user@incubator.apache.org
Subject: Re: Views
In-Reply-To: <0B8FCF82-C889-4BF6-8CF8-AE9040BD76B5@gascard.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <0B8FCF82-C889-4BF6-8CF8-AE9040BD76B5@gascard.net>

Anthony,

http://wiki.apache.org/couchdb/ViewCollation is the way to accomplish
tasks like that.

Christopher Lenz has a write-up of how to use view collation to sort
views, achieving comments grouped by parent blog post.

 http://www.cmlenz.net/archives/2007/10/couchdb-joins

In your case you could index a view with date and type, like this

[type, date]

and then if you had say 5 types you'd do 5 GET queries against the
database, each one fetching only the documents for that day.

View collation is one of my favorite things about CouchDB. I'm excited
about reduce, because from what I understand, you could use it to
lower this to 1 GET, if that's important to you.

enjoy,
Chris

On Fri, Apr 25, 2008 at 9:34 PM, Anthony Mills <amills1037@gascard.net> wrote:
> I read most of the documentation, wiki and blogs, but I still do not see how
> to accomplish a certain scenario.  Hopefully I can describe it adiquitely.
>
>  Lets say I have 1,000,000 documents [all of the same "type"] with a date
> attribute.  Lets say I want to pick a subset of those documents.  How can I
> pick those documents of one type that fall on one day?  Will I need to get
> all 1,000,000 documents?  What if I want all documents of one type on one
> day that match another attribute?
>
>  I pretty sure this is what map/reduce will help with, but is there a way to
> do this now?  Can you use more documents to build date relations?
>
>  Also, can you pass more variables than just key to the view function?
>
>  Thank you,
>
>  Anthony
>


-- 
Chris Anderson
http://jchris.mfdz.com