Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Remote » Managing SQL Remote systems » Improving SQL Remote performance


Improving performance when receiving messages

The major bottleneck for total throughput in a SQL Remote system is generally receiving messages from many remote databases and applying them to the database. To reduce this lag time, when running a SQL Remote Message Agent (dbremote) in continuous mode, you can adjust the following variables:

Adjusting the polling interval to check for new messages
Adjusting throughput by caching received messages
Adjusting the requests to resend messages
Adjusting the number of worker threads