Which among the above options is best suitable from performance and database management point of view regardless of security?
Hi Noor,
I’m not sure with ‘best’ suitability, as this depends a lot on your requirements.
In regards to performance and database management, having a separate instance/deployment would likely be preferable. As you would be able to handle a tenant with massive data volume and/or process-intensive separately (scale up/down clusters).
Depending on your requirements, have you considered using MongoDB Atlas ?
In MongoDB Atlas, you can create an organisation which may contain many projects. Within a project you can associate clusters/deployments. See also MongoDB Atlas: users and teams
Regards,
Wan.