Hi guys, I am building and in house web app that will be used by clients from different countries. Some of the functionalities and services is based on country of the client. My current design is to have one database for the application where the country field from the client_details table is used to filter clients by country when necesary.
A friend proposes that a better option will be to have a seperate database for each country. In this case is he right and if so how can this inprove the overall application? Links will also be apprecaited where I can go and educate myself some more on such a design if its indeed a better choice.
Thanks