incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Lehnardt <...@apache.org>
Subject Re: Considerations for lots and lots of databases?
Date Sat, 10 Jan 2009 18:16:13 GMT

On 10 Jan 2009, at 19:07, Chris Anderson wrote:

> On Sat, Jan 10, 2009 at 9:19 AM, Kurt Mackey <kurt@arstechnica.com>  
> wrote:
>> 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?
>>
>
> CouchDB keeps each database in it's own file, so if you can spread the
> files across disks (using symlinks for now) you should get better
> performance with many databases. DB-per-user is a good pattern also
> because it means you can let users replicate their entire account
> locally, without worrying about filtering out extra data.
>

In addition, if you name your databases "foo/bar" CouchDB will actually
create that as a structure on disk to avoid running into trouble with
filesystems that don't like a lot of files in a single directory.

Setups with 1 million databases representing users have been tested
successfully.

Cheers
Jan
--

Mime
View raw message