Hi all !
Is it good practice to a have a separate database for a different group of people, say people in a different country.
For e.g. If I run a franchisee business model in different countries, would it be a good thing to have a separate database based on the country? I was thinking of naming the database prepended by country name like USA_mydatabase, Canada_mydatabase and so on.
Would that be ok ? What is the best practice in such cases.
Thanks all !