I recently learned about multitenancy and I'm wondering if the approach our provider took setting up our Navision environment is the most effective.
We are a multinational company and we are hopeing to integrate a total of 6 countries in NAV. From what i read, one of the cons of having a multi companies set up is security, any admin could see other companies information since everything is in a DB. However, I don't know if this has any impact performance wise.
On the other hand, from what I read multitenancy pretty much separates the application DB and creates multiple data DB. So that way you have a DB per tenant.
My question is... Are we taking the right approach continuing with a multi companies or multitenancy is a better choice?
Security wise, we as a company, don't have a problem since there is only one admin that oversees all countries. My main concern is backing up data and performance. Since everytime we create a new company NAV creates the 500+ tables in our main DB and with only two month data we feel NAV is a bit slow.
Any answer from you, experts, will be greatly appreciated.
