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 wout.mertens@gmail.com
 designates 209.85.215.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=MIGlvw4sUVG7JLAP3enilxUM4J9gXQVrczBK0Y+u+ATlSXCuG0cuJg4O+atMov5kEU
         gTfTLJrpcSc9sM8s7txvU0D7GWsMSZGn//kLnut85C67EUAtfniPtXESe4SYFeR62TWX
         LXtnA7aPWk7kWb2Gic9Lt+aKxt46uVuWCH7FM=
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1081)
Subject: Re: Question on view design for both Hierarchy and Date.
From: Wout Mertens <wout.mertens@gmail.com>
In-Reply-To: <AANLkTinjyWT7Ohct4BFGG0J5AribM4KPKVK-xZV4G8+w@mail.gmail.com>
Date: Mon, 27 Sep 2010 14:01:06 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <C0CE02E4-711A-4299-BDF9-77EE15503ED1@gmail.com>
References: <AANLkTinDB9JAH+-BRiHZXfL5Fo9pgXaM36dcfPxmi0RR@mail.gmail.com>
 <AANLkTikWGRoSEP=DchAEXUVAKqdPz6iNQYcdzR-x5zAc@mail.gmail.com>
 <AANLkTinjyWT7Ohct4BFGG0J5AribM4KPKVK-xZV4G8+w@mail.gmail.com>
To: user@couchdb.apache.org

On Sep 26, 2010, at 13:02 , S=F8ren Hilmer wrote:

> Hi
>=20
> A few questions to your comments
>=20
> On Thu, Sep 23, 2010 at 10:06 PM, Wout Mertens =
<wout.mertens@gmail.com>wrote:
>=20
>> 2 comments:
>> - your time is a fixed-length string (until the year 10000 ;)) so you
>> could just leave it as-is instead of splitting it
>>=20
>=20
> Yes, but will that allow me to do the sum on a monthly basis, like =
with this
> query for september:
> startkey=3D["A","B","c6",2010,9,1]&endkey=3D["A","B","c6",2010,9,31,{}]

Simply query for =
startkey=3D["A","B","c6","2010-09-01"]&endkey=3D["A","B","c6","2010-09-32"=
]

>> - using group=3Dtrue you can get the sum for each sub level in your =
key
>> array so you don't have to emit the full path. Just emit the path and
>> then the time.
>>=20
>=20
> Hmm, if I do that how do I query the sum under for instance the root =
for a
> period?

Oh I see. Yeah you can't do that unless you use multi_views which are in =
development.

Basically you have a 2-dimensional search space (path and time) and =
you're cheating your way into 1-dimensionality by preparing all the =
possible 2-dimensional queries you might ask. That works but it costs =
you disk space obviously.

Wout.