Hi all, I have a design question. Lets say that my solution will serve hundreds (or even more than 1000) customers. For each customer I will need 4 to 6 sets of objects, say: assets, address book, meetings and meeting results. I wonder what would be best approach here: - have userDB's for each customer with documents identified by type (this means potentially thousands of db's), or: - have 6 db's, one per document type and filter by customer ID.
There might be thousands of documents of each type per customer, eventually bringing the total number of documents to millions. How each of the approaches above will affect clustering and what will be the best cluster setup. In terms of performance and indexing, does one of the designs outperforms the other? Thanks in advance, Kiril.
