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 creating 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.
On Sun, Nov 10, 2013 at 1:34 PM, Jens Alfke <[email protected]> wrote: > > On Nov 9, 2013, at 11:47 AM, Robert Newson <[email protected]<mailto: > [email protected]>> 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 > 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. > > —Jens >
