If you find that your DataSync Agent is running slowly due to a large number of SQL statements being processed, you may want to configure the Agent to perform SQL statements in batches. NOTE: This feature should only be used when you send messages of the same table into one queue. If your queue has messages from different tables (including sys_audit, sys_journal_field, sys_attachment and sys_attachment_doc records), do not enable this feature as it will cause errors in saving records. To properly use this feature, separate your dynamic and bulk shares to save each type of table record to a different queue. To do this, open the agent.xml file that was created upon installation of your Agent in a text editing application. Within the <task> directive of the agent.xml file, nest the following directives: Directive | Description |
---|
<batch_update/> | Self closing tag that configures your Agent to batch SQL UPDATE statements | <batch_insert/> | Self closing tag that configures your Agent to batch SQL INSERT statements | <max_batch_size> | Number of SQL statements that will trigger a batch SQL statement execution. A larger suggested value is 200. NOTE: By default, this directive's value will be set to 10. |
|