Change Replication Server Connection Parameters to Improve Performance

You can use configuration parameters to improve replication 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 Replication Server Administration Guide Volume 2 > Performance Tuning > Configuration Parameters that Affect Performance for a general discussion of performance and configuration parameters. See also Replication Server Administration Guide Volume 2 > Performance Tuning > Use Parallel DSI Threads.

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

See Replication Server Reference Manual > Replication Server Commands > configure replication server for more information about the memory_limit and num_threads parameters.

Increasing 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 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'