Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 93417 invoked from network); 10 Jan 2009 18:16:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 10 Jan 2009 18:16:17 -0000 Received: (qmail 36531 invoked by uid 500); 10 Jan 2009 18:16:16 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 35964 invoked by uid 500); 10 Jan 2009 18:16:15 -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 35953 invoked by uid 99); 10 Jan 2009 18:16:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 10 Jan 2009 10:16:15 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of theflinnster@gmail.com designates 209.85.217.10 as permitted sender) Received: from [209.85.217.10] (HELO mail-gx0-f10.google.com) (209.85.217.10) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 10 Jan 2009 18:16:06 +0000 Received: by gxk3 with SMTP id 3so663565gxk.23 for ; Sat, 10 Jan 2009 10:15:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:from:to :in-reply-to:content-type:content-transfer-encoding:mime-version :subject:date:references:x-mailer; bh=g///JG4iQ3f04wNF7oOfdrL875kpCPVTpyOm4+B2E6E=; b=EnK923mwlYhSdQhvio7khKJQLN8Ji2FW+lqHcN8iHBmYo/KcUNQZMPvWJzN09OFZuj 05dgsE0rPR8ed+f8MZdK2vWIilObaMwJsLymyg/TuJYvWMBjnS0OBRM9+SxfKUKOldgS oMi6nHrg/RPIGRV2+azHQvNRCuPo2bqAghj0k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:in-reply-to:content-type :content-transfer-encoding:mime-version:subject:date:references :x-mailer; b=USbg7KOcummrM9ZAU3J4MFRQMSLw2G2EbzX/iNcrKnOHNQVmnkbGZ/fdiG+lnm3vvq gO736xKxdf8c8Rsj1FKpz4pCbMePKRlwZIbf4DSNuB0yIH1At9UPoOGwUi012v7CJ1nQ biMUV2XWwiMHHRZM9uDoY1BAtNB4j9/5fdH4U= Received: by 10.150.219.16 with SMTP id r16mr6660585ybg.109.1231611345115; Sat, 10 Jan 2009 10:15:45 -0800 (PST) Received: from ?192.168.1.5? (c-71-235-225-250.hsd1.ct.comcast.net [71.235.225.250]) by mx.google.com with ESMTPS id 58sm47070832rnw.7.2009.01.10.10.15.43 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 10 Jan 2009 10:15:43 -0800 (PST) Message-Id: <2D2F5D7F-FAC7-44C9-A43C-C6135AADC743@gmail.com> From: Flinn Mueller To: user@couchdb.apache.org In-Reply-To: Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v930.3) Subject: Re: Considerations for lots and lots of databases? Date: Sat, 10 Jan 2009 13:15:40 -0500 References: X-Mailer: Apple Mail (2.930.3) X-Virus-Checked: Checked by ClamAV on apache.org Kurt, what language/framework are you planning to use for the project? On Jan 10, 2009, at 12:19 PM, Kurt Mackey wrote: > I really, really like not having to deal with schema updates. Given > that I don't have to worry about this in quite the same way with > Couch, I've been wondering what the downsides are to splitting data > into multiple databases on a SaaS project. The idea is that each > account/customer would get their own database, rather than simply > marking documents with an "owner". > > Now, the obvious downside is that it makes it more difficult to do > cross-customer queries. But what other problems are there with this > idea? Assuming that there were lots and lots and lots of accounts, > what performance implications are there to giving each their own DB > rather than making them all share? > > -Kurt