You control the interval to wait between polls for more data from the transaction log to send using the -sd option, which has a default of one minute. The following example sets the polling interval to 30 seconds:
dbremote -sd 30s ... |
Alternatively, you can poll less frequently, as in the following command line, which polls every five minutes:
dbremote -sd 5 |
Setting a very small interval may have some detrimental impact on overall system throughput, for the following reasons:
Setting larger intervals may provide a better overall throughput of messages in your system, at the cost of waiting somewhat longer for each message to be applied. In many SQL Remote installations, optimizing turnaround time is not the primary concern.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |