Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of jens@couchbase.com designates
 206.225.164.29 as permitted sender)
From: Jens Alfke <jens@couchbase.com>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Date: Sun, 10 Nov 2013 10:34:32 -0800
Subject: Re: Storage limitations?
Thread-Topic: Storage limitations?
Thread-Index: Ac7eQ36wUGY6ix0OQC+JN5xTLZ+4NA==
Message-ID: <1CD5C733-4854-407A-A8DF-8E29A1A0493B@couchbase.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>
In-Reply-To: 
 <CABvT1DEnX0He=ZvYF5ucHcAJGphwso2vajS8jSd6fBLtzLA0Ag@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_1CD5C7334854407AA8DF8E29A1A0493Bcouchbasecom_"
MIME-Version: 1.0

--_000_1CD5C7334854407AA8DF8E29A1A0493Bcouchbasecom_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


On Nov 9, 2013, at 11:47 AM, Robert Newson <rnewson@apache.org<mailto:rnews=
on@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 large
with attachments.

But on the other hand, all attachments will get copied during a database co=
mpaction, so they slow down the process and require more free disk space. I=
f you have many gigabytes of attachments, you might consider storing them e=
xternally 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

--_000_1CD5C7334854407AA8DF8E29A1A0493Bcouchbasecom_--