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

SQL Anywhere 11.0.1 (Français) » SQL Remote » SQL Remote Deployment and Administration » SQL Remote Administration » Improving SQL Remote performance » Improving performance when sending messages


Adjusting how quickly resent requests are processed

Because resending a message interrupts the regular message sending process, the Message Agent (dbremote) delays processing resend requests. By default, the Message Agent (dbremote) waits for a time that is half of the send frequency of the remote user who requested the resend.

To resend a message, the Message Agent (dbremote) does the following tasks:

  • It stops scanning the transaction log and stops building new messages.

  • It deletes the current messages that are stored in its cache waiting to be sent. All of the work that the Message Agent (dbremote) did in reading the transaction log and building those messages is lost.

  • It re-reads the transaction log from the offset requested in the resend request. The Message Agent (dbremote) builds the messages and stores them in its cache.

  • It waits until the next send frequency time occurs and then sends the messages.

You must balance the urgency of sending requests for resent messages with the priority of processing regular messages.

The -ru option controls the urgency of the resend requests. To delay processing resend requests until more have arrived, set this option to a longer time. For example, the following command waits one hour before processing a resend request:

dbremote -c "DSN=SQL Anywhere 11 Demo" -ru 1h

See Message Agent (dbremote).

See also