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 <[email protected]> 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
