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
|