Previous Topic: How SS Handles Messages—Bulk Update Disabled, Stage Check DisabledNext Topic: Configure Bulk Update Configuration Policies for SS


How to Optimize Database Transactions

Optimizing database transactions is a two-step process that involves running the scalability server in the bulk update mode and configuring the Installation Manager to perform optimized transactions. The scalability server sends multiple individual messages in the form of a single message to the Installation Manager, and the Installation Manager commits multiple records in one shared database transaction.

Therefore, to achieve performance improvement in terms of database transactions by updating the job status messages and the software records in bulk, make sure that you configure the scalability server and the Installation Manager as follows:

  1. Configure the bulk update configuration policies for the scalability server to run the scalability server in the bulk update mode.
  2. Configure the optimized transaction configuration policies for the Installation Manager to use the optimized transactions on the Installation Manager.

More information:

Configure Bulk Update Configuration Policies for SS

Configure Optimized Transaction Configuration Policies for IM