A standard Datagate installation on a single server covers the needs of most small and medium-sized businesses. As the volume of transactions increases, the number of competing users multiplies or new modules are added, signs of slowing down can appear: pages that load more slowly, reports that take longer, background tasks that lag.
In these cases, Datagate offers several scaling strategies, applicable incrementally — from the simplest to the most advanced.
Separating the database from the application is the recommended first step. The database server and application server run on different machines, each with dedicated resources. The database no longer competes with the web application for the same CPU and RAM. This is the recommended configuration for any high-volume production deployment.
Web farm (multiple instances) involves adding additional instances of the web application, distributed behind a load balancer. When one court is busy with a costly operation, new claims are taken over by another court. This approach directly increases the capacity of competing users.
The separation of tasks on dedicated servers goes a step further: the different modules run on their own servers. One server serves the stores, another the warehouse, another the SFA. Traffic from field sales agents no longer affects the performance of warehouse operators. Each server can be sized independently, depending on the specific load.
SQL Server scaling — adding CPU cores to the database server directly improves the performance of complex queries and parallel operations (reports, recalculations, synchronizations).