From user-return-32120-archive-asf-public=cust-asf.ponee.io@couchdb.apache.org Sun Feb 9 16:02:20 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 54AF418065D for ; Sun, 9 Feb 2020 17:02:20 +0100 (CET) Received: (qmail 60505 invoked by uid 500); 9 Feb 2020 16:02:19 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 60493 invoked by uid 99); 9 Feb 2020 16:02:18 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Feb 2020 16:02:18 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 577C81A40CF for ; Sun, 9 Feb 2020 16:02:18 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.284 X-Spam-Level: X-Spam-Status: No, score=0.284 tagged_above=-999 required=6.31 tests=[KAM_DMARC_STATUS=0.01, KAM_SHORT=0.001, RCVD_IN_DNSWL_LOW=-0.7, SPF_HELO_NONE=0.001, SPF_SOFTFAIL=0.972] autolearn=disabled Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id c-HLrOEr1tlM for ; Sun, 9 Feb 2020 16:02:16 +0000 (UTC) Received-SPF: Softfail (mailfrom) identity=mailfrom; client-ip=217.70.178.232; helo=relay12.mail.gandi.net; envelope-from=couchdb@wordit.com; receiver= Received: from relay12.mail.gandi.net (relay12.mail.gandi.net [217.70.178.232]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id EA7167DD70 for ; Sun, 9 Feb 2020 16:02:15 +0000 (UTC) Received: from [10.12.12.3] (unknown [152.89.163.24]) (Authenticated sender: mailboxone@wordit.com) by relay12.mail.gandi.net (Postfix) with ESMTPSA id ABF33200004 for ; Sun, 9 Feb 2020 16:02:12 +0000 (UTC) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Marcus Mime-Version: 1.0 (1.0) Date: Sun, 9 Feb 2020 17:02:11 +0100 Subject: Maximum number of databases? Message-Id: To: user@couchdb.apache.org X-Mailer: iPod touch Mail (17D50) How many databases can be used without causing issues with replication and s= erver performance? I found two very different opinions. The pouchdb blog quotes 100K (based on a= discussion about Cloudant in 2014). However a Cloudant blog series from Mar= ch 2019 recommends a maximum of 500. Can anyone explain the huge difference? I understand it's going to depend on= use cases, but a difference of 90,500 databases is significant.=20 500 are too few when databases are needed for read access control using role= s. One for each user's personal document locker, one for public data (web), a= nd one for a private group. That leaves about 160 users. Here are two excerpts from that Cloudant blog series of March 2019. "Rule 4: Fewer databases are better than many If you can, limit the number of databases per Cloudant account to 500 or few= er. While there is nothing magical about this particular number (Cloudant ca= n safely handle more), there are several use cases that are adversely affect= ed by large numbers of databases in an account." "Rule 5: Avoid the =E2=80=9Cdatabase per user=E2=80=9D anti-pattern like the= plague If you=E2=80=99re building out a multi-user service on top of Cloudant, it i= s tempting to let each user store their data in a separate database under th= e application account. That works well, mostly, if the number of users is sm= all." Source: https://www.ibm.com/cloud/blog/cloudant-best-and-worst-practices-par= t-1 What are your personal experiences with large numbers of databases? Marcus