- Local Area Network (LAN)
- Private Cloud Platform
- Troika Application over VPN (not supported)
Local Area Network
Operating Troika and WealthWorks+ within the Local Area Network is the most popular operating model for the application. A hardwired network environment where the Troika Desktop application (utilising MSAccess) runs on the same LAN as the SQL server. WealthWorks+ running on Internet Information Services (IIS) and is also accessed via the LAN.
Further information on our product's System Requirements can be found here.
Private Cloud Platform
SQL Server and the Remote Desktop Server(s) will both need to be in a private cloud, with a secure VPN for remote desktops to connect to, for the Troika Desktop application.
Key points to consider for your proposed cloud environment, including Azure and AWS, would be:
- Ensure the specification of the servers which will be hosted within the cloud platform meet our standard System Requirements found here.
- Ensure enough SQL Server memory requirements are met. Further information on this can be found here.
Troika Application over VPN (not supported)
Troika will not operate over a VPN alone, where users are connecting a desktop installation of Troika to a SQL Server. Users would experience poor response times, connection time-outs and other performance related issues.
For Troika to work effectively, the application must be on the same Local Area Network as the SQL database. Network traffic between the Troika application and SQL would operate extremely slowly and is not recommended as an operating model.
Troika continually passes large amounts of data between the application and SQL database. Performance within Microsoft Access can suffer when connecting to a SQL database over VPN. It will vary depending on the internet connection speed; generally being slower on a WiFi connection than on a hardwired connection. However, no matter the internet speed, the performance can be so slow, it often makes the application unusable.
The root cause of this performance issue is the inherent high levels of latency that is found in these Wide Area Network (WAN) topology, created by the high levels of TCP/IP traffic, and encryption between the application and the SQL database.
In remote working/working from home situations we would always recommend a thin client topology; one that moves the application to the same location/local area network as the SQL database. Users can then connect using Remote Desktop, Citrix or in an MSAzure situation, an Azure Virtual Machine, to use Troika efficiently.