couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Joseph Davis <paul.joseph.da...@gmail.com>
Subject Re: Query across databases
Date Sat, 31 Oct 2009 01:55:53 GMT
Create a background process that writes post/comment pairs to a new db  
and query the derivative data.



On Oct 30, 2009, at 9:45 PM, Devin Guedo <devin.guedo@gmail.com> wrote:

> hi all,
>
> I was wondering what would be the optimal way to query across  
> databases?
>
> Quick example; you have a SAS blog platform. Each blog has its own  
> database,
> storing the individual posts and comments as separate documents. You  
> write a
> view that counts the comments for individual posts. Essentially a  
> list of
> posts, in order, by their comment count. But, now you want a global  
> list, a
> top 100 posts based on comment count from across the whole site,  
> spanning
> all databases. How would one do that efficiently?
>
> Thanks

Mime
View raw message