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:
How often the SQL Remote Message Agent (dbremote) checks for incoming messages.
How much memory is used by the SQL Remote Message Agent (dbremote) for holding messages to be sent.
How long the SQL Remote Message Agent (dbremote) waits for an out-of-order message to arrive before requesting that the message be re-sent.
How many worker threads are used to process the received messages.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|