Changing Replication Server connection parameters to improve performance

Sybase sets default values for configuration parameters for average installations and usage. Depending on your system configuration and how Replication Server is used at your site, you may find that careful altering of certain default values may improve performance. See “Configuration parameters that affect performance” on page 137 in the Replication Server Administration Guide Volume 2 for a general discussion of performance and configuration parameters. See also “Using parallel DSI threads” on page 158 in the Replication Server Administration Guide Volume 2.

If you are adding many new connections, you may want to change the memory_limit or num_threads Replication Server parameters to improve performance.

Increasing the memory_limit

To increase the amount of memory specified for Replication Server, increase the value specified for the memory_limit parameter by using configure replication server at Replication Server.

For example, execute configure replication server in the following manner to increase memory_limit to 25MB:

configure replication server
    set memory_limit to '25'

Increasing the num_threads

You may need to increase the number of Open Server threads that the Replication Server can use. To do this, increase the value specified for the num_threads parameter, using configure replication server at the Replication Server.

For example, execute configure replication server in the following manner to increase num_threads to 70:

configure replication server
		set num_threads to '70'

See configure replication server in Chapter 3 “Replication Server Commands” in the Replication Server Reference Manual for more information about the memory_limit and num_threads parameters.