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 paul.joseph.davis@gmail.com
 designates 74.125.44.30 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=btPTvSfdC+cqAqhfi7gcZmiBwFmPRxnV1M3XulQ7mJ3hnqoEpXT8IY4kJLmeMpj+sA
         plkDNNPuusV0Va6gNQ62olYNXxzhYTB4rFl9Gv2Ruk2YSgRJtCiDCzc1KaqVaXQvcYSy
         kn/rAwDnOXMT6eL6EnTIhSR8jg6hozd8Hblqo=
MIME-Version: 1.0
In-Reply-To: <b66ddc900904040004o6486217ao4f3c20744e66e7ae@mail.gmail.com>
References: <b66ddc900904040004o6486217ao4f3c20744e66e7ae@mail.gmail.com>
Date: Sat, 4 Apr 2009 11:20:47 -0400
Message-ID: <e2111bbb0904040820l360b28afv151403fe5ceb80c6@mail.gmail.com>
Subject: Re: Some basic couchdb questions
From: Paul Davis <paul.joseph.davis@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On Sat, Apr 4, 2009 at 3:04 AM, howard chen <howachen@gmail.com> wrote:
> Some quick questions:
>
> 1. How many DB can be created in a single couchdb server?

More than 500,000 have been created. Not sure what the current maximum
reported number is.

> 2. Are there any length limit on key & value of a document?

HTTP post bodies are limited in size by mochiweb to something like
4GiB which indirectly limits CouchDB document sizes. The amount of
available RAM is also a limit. A single member on the document should
not be limited in size. Map/Reduce key values are not limited in size.
Results returned from reduce functions should stay relatively small in
size. growing at less than approximately log(# keys reduced).

> 3. WIll there be max. number of documents?

Nothing enforced directly by couchdb. The only limit should be the
relative hardware limits.

> 4. I found that when inserting large ammount of rows into couchdb, it
> is quite slow (e.g. due to UTF-8 conversion, due to HTTP call...etc),
> are there any way to improve?
>

What versions of Erlang and CouchDB and how are you inserting data?

If you're not at least on 0.9 and one of the last two or three
releases of Erlang you should upgrade both. Also, make sure that
you're using bulk docs to load your databases on initial import. Also,
for extra bonus points, sort all of your documents before loading,
though this is least important.

HTH,
Paul Davis

>
> Thanks.
>