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

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Managing SQL Remote systems » SQL Remote performance » Performance when receiving messages


Database worker threads

The following steps describe how the SQL Remote Message Agent (dbremote) applies incoming messages:

  1. It reads the messages. Messages are read and the header information is examined (to determine the correct order of application). Reading messages from the message system is single-threaded.

  2. It applies the messages. Read messages are passed off to database worker threads to be applied.

    On remote databases, the messages are usually applied serially. In a multi-tier system, a remote database can also be a consolidated database for other remotes. On this type of a remote database, the messages are applied as on a consolidated database.

    On the consolidated database, the default is to apply the messages serially. You can use additional database worker threads to apply incoming messages from remote users in parallel. See the -w option in SQL Remote Message Agent utility (dbremote).

    When database worker threads are used on a consolidated database:

    • Messages from different remote users are applied in parallel.

    • Messages from a single remote user are applied serially.

      For example, ten messages from a single remote user are applied by a single worker thread in the correct order.

 Advantages of using database worker threads
 Disadvantages of using database worker threads
 Setting the number of database worker threads
 See also