SQL Remote User's Guide
  SQL Remote Administration
    Tuning Message Agent performance
      Tuning incoming message polling

Example

Suppose there are two remote users, named user1 and user2, and suppose the Message Agent command line is as follows:

dbremote -rd 30s -rp 3

In the following sequence of operations, messages are marked as userX.n so that user1.5 is the sixth message from user1. The Message Agent expects messages to start at number 1 for both users.

At time 0 seconds:

1. The Message Agent reads user1.1, user2.4

2. The Message Agent applies user1.1

3. The Message Agent patience is now user1: N/A, user2: 3, as an out of sequence message has arrived from user 2.

At time 30 seconds:

1. The Message Agent reads: no new messages

2. The Message Agent applies: none

3. The Message Agent patience is now user1: N/A, user2: 2

At time 60 seconds:

1. The Message Agent reads: user1.3

2. The Message Agent applies: no new messages

3. The Message Agent patience: user1: 3, user2: 1

At time 90 seconds:

1. The Message Agent reads: user1.4

2. The Message Agent applies: none

3. The Message Agent patience user1: 3, user2: 0

4. The Message Agent issues resend to user2.

When a user receives a new message, it resets the Message Agent patience even if that message is not the one expected.