How to manage the server load of Sapho ETN jobs
Category: Sapho Server
Audience: System administrators installing and configuring Sapho Server
In order to effectively implement Sapho’s proprietary Extract, Transform, prepare to Notify (ETN) technology, Sapho server uses a scheduler to manage the execution of various background jobs, such as data synchronization and event processing.
To manage the number of threads available for the concurrent execution of jobs, i.e. set the maximum number of jobs that can be run in parallel, you can use the following environment variable:
By default, the number of threads set in Sapho is 3, but this variable can be set to any positive integer, although you should realize that only numbers between 1 and 100 are practical.
Depending on your environment, you may want to tweak this number for performance. If you are running big jobs (e.g. syncing large amounts of data) on a single server, we recommend setting the thread pool size to 1. If you are running Sapho on a cluster, you can set the thread pool size to a larger number. As a best practice, we also recommend monitoring your server to make sure it’s not overloaded.