We are hosting one database with many companies. These companies are in different places around the world, where users connect in with windows client. I am wondering if there can be a local service tier that would improve performance? Or does it more so rely on the location of the database when talking about performance?
*This post is locked for comments
In this scenario (single database, N companies in different locations), using N separated service tiers for the different companies is the best way to do (you can decouple users, tasks on a company don't disturb tasks on another company and so on). This is absolutely the recommended way to do.
Regarding service tier location, it depends :) My suggestion is to leave service tier as close as possible to your database. So, you could have a scenario where you have NAV database (SQL Server) on a server A and Service Tier 1,2,3...N on separated servers on the same network as the database server. Windows Client from different companies will connect to the respective service tier, maybe using a VPN. This is the scenario with best performances. Obviously, you need to check the network latency of the different companies.
So just to be clear, does that mean we may have one Database in Europe with clients in USA, EU, Asia - and there should also be a service tier server in USA, EU, Asia instead of all clients just connecting to one service tier located close to the Database server?
Assuming that is possible - is there a performance improvement in doing this?
Multi-Tenant will obviously have an impact on Performance, This was the only reason it was introduced where Customer was having n number of companies.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (