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 mark.deibert@gmail.com
 designates 209.85.212.42 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAMGHjAT2GQYjmRp=ntDRAMZGGAFtRbKfUVW0zU+mCY6yh=BSjQ@mail.gmail.com>
References: 
 <CAMGHjASjaVagGbvOGSJrPitoVVDN0qn7BxahT4y3t1XeRcHekg@mail.gmail.com>
	<527E548F.4020203@yandex.ru>
	<CABvT1DHMwHDAB4yc19h2z9avxfJOQ3Yp5FnQyBimULuGa5NJ_w@mail.gmail.com>
	<CAMGHjATWVSc4WyJ4N3g-roGkPKMxEF_DwmXieuy7qS3wugTYpA@mail.gmail.com>
	<CAK0S_BDsCRwUXBSUtjr-rBMXJuw_JcdhdTDLKUYckPj5+BC7XA@mail.gmail.com>
	<CABvT1DEnX0He=ZvYF5ucHcAJGphwso2vajS8jSd6fBLtzLA0Ag@mail.gmail.com>
	<1CD5C733-4854-407A-A8DF-8E29A1A0493B@couchbase.com>
	<CAMGHjARqtzUWujNn6EW-v1BAk=XYSp3_Ru8VNwgmeYb_M=m8Zw@mail.gmail.com>
	<CAKiq=tATz_ymdvX7mfGowM2xY82jniz1_-RjJ5Dj7gGKZP43AA@mail.gmail.com>
	<CAMGHjAT2GQYjmRp=ntDRAMZGGAFtRbKfUVW0zU+mCY6yh=BSjQ@mail.gmail.com>
Date: Sun, 10 Nov 2013 17:14:42 -0500
Message-ID: 
 <CAMGHjAQ4qqu=eHm31L7T9fDN90Fiit3rjMGQOprF+7DsvN8rxw@mail.gmail.com>
Subject: Re: Storage limitations?
From: Mark Deibert <mark.deibert@gmail.com>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Type: multipart/alternative; boundary=20cf307f324634cd9004ead9f1a3

--20cf307f324634cd9004ead9f1a3
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I read an article somewhere that using include_docs is "hard" on memory or
disk or in some way taxes Couch and therefore you should just emit the doc.
Is this true?


On Sun, Nov 10, 2013 at 5:11 PM, Mark Deibert <mark.deibert@gmail.com>wrote=
:

> BTW, my current code _is_ storing each comment as it's own doc, and I
> already _do have_ and am using the view that is being described here. I w=
as
> just trying to figure out something more denormalized. However, Keith's
> comment about the conflicts might be nail. I didn't think about that.
>
>
> On Sun, Nov 10, 2013 at 5:00 PM, Mike Marino <mmarino@gmail.com> wrote:
>
>> Hi Mark,
>>
>> On Sun, Nov 10, 2013 at 10:10 PM, Mark Deibert <mark.deibert@gmail.com>
>> wrote:
>> > Each comment is normally a very small amount of information, and id,
>> > userName, a date and a small text field. Probably no more than a short
>> > sentence on average. Why do I need to go through the trouble of creati=
ng
>> > new comment docs for each? This totally complicates the comment read
>> code
>> > (there will 1000 reads to every 1 write, at least) both in the UI and
>> the
>> > db for no reason.
>>
>> I'm not sure why this should complicate the comment read code.  You
>> can generate a view that emits as key the particular page/post to
>> which the comment refers.  As value, you can emit either a subset of
>> data you need from the comment, or simply emit "null" and call the
>> view with include_docs to get all the documents for the particular
>> post.  This would be a single http call.
>>
>> Cheers,
>> Mike
>>
>> >
>> >
>> > On Sun, Nov 10, 2013 at 1:34 PM, Jens Alfke <jens@couchbase.com> wrote=
:
>> >
>> >>
>> >> On Nov 9, 2013, at 11:47 AM, Robert Newson <rnewson@apache.org<mailto=
:
>> >> rnewson@apache.org>> wrote:
>> >>
>> >> attachments are different to documents. They're stored as a series of
>> >> binary chunks and so they can be streamed in and out, you can go larg=
e
>> >> with attachments.
>> >>
>> >> But on the other hand, all attachments will get copied during a
>> database
>> >> compaction, so they slow down the process and require more free disk
>> space.
>> >> If you have many gigabytes of attachments, you might consider storing
>> them
>> >> externally and putting URL links in the documents.
>> >>
>> >> As for comments, just add new documents for each comment and use a
>> >> view (https://wiki.apache.org/couchdb/HTTP_view_API,
>> >> https://wiki.apache.org/couchdb/View_collation) to bring the article
>> >> and comment thread together. No need to update a document that way.
>> >>
>> >> Yup. The guide <guide.couchdb.org<http://guide.couchdb.org>> has a
>> >> chapter-long example of a blog application that shows how to do
>> comments
>> >> this way.
>> >>
>> >> =97Jens
>> >>
>>
>
>

--20cf307f324634cd9004ead9f1a3--