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

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Deployment and Administration » SQL Remote Administration » 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 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 messages
Adjusting the requests to resend messages
Adjusting the number of worker threads