How to manage the server load of Sapho ETN jobs

Last update:

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:

SAPHO_JOB_THREAD_POOL_SIZE

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.