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 dch@jsonified.com designates
 209.85.214.53 as permitted sender)
Date: Fri, 27 Sep 2013 12:44:39 +0200
From: Dave Cottlehuber <dch@jsonified.com>
To: user@couchdb.apache.org
Message-ID: <etPan.52456197.643c9869.8980@akai.jsonified.com>
In-Reply-To: <52455FFD.9000506@gmail.com>
References: <52455FFD.9000506@gmail.com>
Subject: Re: database limits: how many dbs can I have in one couchdb
 instance
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

>Hi all,
>
>meanwhile the patch for =22validate=5Fdoc=5Fread=22 is not applied I am =
studying
>different workarounds.
>
>One valid solution for our use case is to create a db for each user and
>store the user specific stuff in that db.
>That has the benefit that we can limit the access to that db with the
>standard security mechanism and we do not
>need to fall back to middleware logic.
>
>The biggest problem I see in the approach is that we need to know what
>is the max number of =22user=22 db
>we can have in one instance. Regarding the size of this db it is
>expected to be a couple of smaller docs.
>
>Somebody has experience with that=3F Like rule of thumb do not deploy mo=
re
>then 10k databases in one instance ...
>
>TIA for any thoughts.
>
>salu2
>
>--
>Thorsten Scherler =20
>codeBusters S.L. - web based systems
>
>
>http://www.codebusters.es/

Hi Thorsten,

The number of DBs doesn't really matter, barring sane OS limits of files/=
dir.

CouchDB uses an LRU cache to keep an=C2=A0appropriate number of DB handle=
s
open for active connections.

A better set of questions to ask is:

- how many active concurrent users (=3D=3D=3D DBs) do you expect=3F
- what sort of replication (esp filtered, continuous =E2=80=A6) do you ex=
pect=3F

A+
Dave