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
