-sm mlsrv12 option

Sets the maximum number of synchronizations that can be actively worked on by limiting the maximum number of network connections.

Syntax

mlsrv12 -c "connection-string" -sm number ...

Remarks

The MobiLink server performs the following synchronization tasks simultaneously:

Read upload data from the network and unpack it.
Apply uploads to the consolidated database.
Fetch rows to be downloaded from the consolidated database.
Pack download data and send it to remote databases.

The number of synchronizations for each task is limited as follows:

The number of synchronizations doing tasks 2 and 3 is less than or equal to the setting for the mlsrv12 -w option.
The number of synchronizations doing task 2 is less than or equal to the setting for the mlsrv12 -wu option.
The number of synchronizations doing all four tasks is less than or equal to the setting for the -sm option.

Higher values for -sm, especially when much greater than -w, allow the MobiLink server to perform more network tasks (1 and 4) than database tasks (2 and 3). This can help ensure that a database worker doesn't have to wait for tasks when network performance might otherwise be a bottleneck. This can improve throughput. However, if -sm is set too high and there are enough concurrent connections, the MobiLink server can allocate more memory than is directly available, causing the virtual memory paging of the operating system to be activated, which in turn causes memory to be swapped to disk—significantly decreasing throughput.