Same as any other web application, for installable cloud apps, the PowerServer Web APIs must be hosted in a server that locates on the same LAN as the database server. If the database is not on the same network as the Web APIs, every request has to go a long way from PowerServer to the database, it is highly possible that there will be performance problems.