Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAK0S_BDsCRwUXBSUtjr-rBMXJuw_JcdhdTDLKUYckPj5+BC7XA@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>
Date: Sat, 9 Nov 2013 19:47:54 +0000
Message-ID: 
 <CABvT1DEnX0He=ZvYF5ucHcAJGphwso2vajS8jSd6fBLtzLA0Ag@mail.gmail.com>
Subject: Re: Storage limitations?
From: Robert Newson <rnewson@apache.org>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

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. The reason I say documents can't be too huge is that
couchdb has to hold them in memory to process them or even return
them.

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.

B.


On 9 November 2013 19:31, Mark Hahn <mark@reevuit.com> wrote:
>> sorting/displaying a comments thread with replies by appending the replies
> within their respective original comment field.
>
> Wouldn't it be more natural to use an array?  And it would be more flexible
> for possible future changes.  It doesn't affect the size of the field but
> there is no way a comment thread is going to get up to even a megabyte.
>  The entire bible fits in a megabyte.
>
>
> On Sat, Nov 9, 2013 at 9:22 AM, Mark Deibert <mark.deibert@gmail.com> wrote:
>
>> Ok I was assuming the db could be really big. I'm storing images so it
>> _will_ get pretty large.
>>
>> For the field size question: I had an idea to greatly simplify
>> sorting/displaying a comments thread with replies by appending the replies
>> within their respective original comment field. Since the order I want to
>> display the comments is the natural chronological order, a simple append
>> process seems to make sense. Haven't tried yet but seems logical.
>>
>>
>> On Sat, Nov 9, 2013 at 11:32 AM, Robert Newson <rnewson@apache.org> wrote:
>>
>> > while the default configuration has max_document_size as 4Gb, it would
>> > be very unwise to make a document anywhere near that large. Database
>> > size is limited only by disk capacity but note that you'll need some
>> > free space for compacting the database.
>> >
>> > On 9 November 2013 15:28, first-leon@yandex.ru <first-leon@yandex.ru>
>> > wrote:
>> > > Base size in no limit. But file system may be limit by file size.
>> > > Doc size limit is 4Gb. (one or two or more field: total - 4Gb)
>> > >
>> > >> I have two storage questions. How big can any one field in one doc be?
>> > >> Also, is there any limit on the size of a CouchDB? Meaning, if I have
>> > 1TB
>> > >> of free disk space, will the db grow to 1TB in size?
>> > >>
>> > >
>> >
>>