I have several databases (db vendorA, db vendorB, db vendorC and so on). The documents within these databases have category field with several values assigned (shoes, caps, jackets and so on)
When a web user picks specific category, I need to select documents based on the chosen category in all the databases and display them on the web, in a single view - for example, all documents that have category "shoes" from all the vendors
I would prefer to keep databases separate.
I am considering to run an agent that would build collection of the documents, but not sure how much load it would bring to the server