-sm option

Sets the maximum number of synchronizations that can be actively worked on, which limits the maximum number of network connections as well.

Syntax 
mlsrv11 -c "connection-string" -sm number ...
Remarks

The MobiLink server performs all of the following tasks simultaneously:

  1. Read upload data from the network and unpack it.
  2. Apply uploads to the consolidated database.
  3. Fetch rows to be downloaded from the consolidated database.
  4. 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 mlsrv11 -w option.
  • The number of synchronizations doing task 2 is less than or equal to the setting for the mlsrv11 -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, 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.

See also
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0