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 faust451@gmail.com designates
 74.125.78.25 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:content-transfer-encoding;
        b=hdZnzijRiBTuJ8iKqaA9DsQ3ZMw7DohRMYND4XUZfnieyaFAqidUVu5BzpwBRj1KaW
         NdYeYq56jFsQebkTuG4FHn2WrzxNuwAPCveaRpvXXan77nvjvFCKmIOpWonWvtG0hseE
         VNjkDc44u53ghF9wrzw/bra7zMBkiSeS0rGbo=
MIME-Version: 1.0
In-Reply-To: <D03D11EE-F5FF-43C1-9AC2-13C7BEA1890C@gmail.com>
References: <AANLkTimTGIz5oiVC8DgNpVMducMlKrxtpFvCqNGmwCAq@mail.gmail.com>
	<46ACF4F3-1F6C-40F6-95C5-4B9286890BBA@gmail.com>
	<AANLkTimwk7jUmaWi-rvnVvIeHA1zlUnnmCW62QjWsVUX@mail.gmail.com>
	<D03D11EE-F5FF-43C1-9AC2-13C7BEA1890C@gmail.com>
Date: Fri, 18 Jun 2010 14:25:20 +0400
Message-ID: <AANLkTin6DZuvbRCKIq-CnAlWz89-PcNDZKFDzGwHb50y@mail.gmail.com>
Subject: Re: Need advice about docs structure design.
From: faust 1111 <faust451@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Chris

> views are processed in batch, so all functions in a design doc are calcul=
ated together.

What is mean?
Example: i keep Bookmarks and Posts in same DB
have two views:
   one fetch Bookmarks
   another fetch Posts

when i called fetch Posts what happens?
  Posts view processed all new+updated docs
  Bookmarks view processed all new+updated docs
  > all functions in a design doc are calculated together.

If i follow you, when i call one view others in design doc are re-calculate=
 too?
is it right?


Thanks!


2010/6/18 J Chris Anderson <jchris@gmail.com>:
>
> On Jun 17, 2010, at 1:37 PM, faust 1111 wrote:
>
>> If i keep =A0them in the same database
>> What about view speed?
>>
>> Example users add many bookmarks and when try fetch Posts each
>> bookmark processed by this view but it's unnecessary it's slow down my
>> views is not it?.
>>
>
> views are processed in batch, so all functions in a design doc are calcul=
ated together. so don't worry about having lots of views.
>
> still, it helps to keep views compact, so only emit what you need from ea=
ch view, even if you have many views. (I break this rule all the time).
>
> mostly, relax about how to store it, and the just write whatever views ge=
t you want you need.
>
> Chris
>
>>
>> 2010/6/18 J Chris Anderson <jchris@gmail.com>:
>>>
>>> On Jun 17, 2010, at 1:15 PM, faust 1111 wrote:
>>>
>>>> Hy guy's.
>>>>
>>>> My model:
>>>> Users has
>>>> =A0Bookmarks and Posts
>>>>
>>>> have idea keep Bookmarks and Posts in separate DB (for speed views).
>>>> But in view i want fetch Bookmarks and Posts with user name,
>>>>
>>>
>>> You should keep them in the same database (replication is easier, too) =
and then use this kind of query:
>>>
>>> http://www.cmlenz.net/archives/2007/10/couchdb-joins
>>>
>>>> In what way i can do this?
>>>> keep copy of users in each DB?
>>>>
>>>> or may be keep users in separate DB, fetch bookmarks or posts and then
>>>> fetch users and then merge?
>>>>
>>>> Yes i know i can copy user name to doc, but have a trouble when user
>>>> name is changed (it's force me use stale=3Dok in request view
>>>> +background process to track changes and run rebuild index).
>>>>
>>>> I think it's will be cool crazy stuff if i can update docs(cached
>>>> fields - not have effect to index) and say Couch you don't need
>>>> rebuild index relax ;).
>>>>
>>>> Any advice?
>>>
>>>
>
>