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

SQL Anywhere 12.0.0 » SQL Remote » Managing SQL Remote systems

 

Improving SQL Remote performance

Each time a row in a table is inserted, deleted, or updated, a message is created for those users subscribed to the row. In addition, an update may cause the subscription expression to change, so that the statement is sent to some subscribers as a delete, some as an update, and some as an insert.

The task of determining who gets what is divided between the database server and the SQL Remote Message Agent (dbremote).

 The database server
 The SQL Remote Message Agent (dbremote)

Receiving message tasks
Improving performance when receiving messages
Sending message tasks
Improving performance when sending messages