Skip to main content

 

ThoughtSpot

How to improve throughput of the load

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

The transaction/commit size value can improve the throughput of the load when setting up the ODBC Driver.

Adjusting the transaction size may correct poor performance and low throughput issues. The transaction size should be set to match the total number of rows that are expected to be loaded in the load cycle. However, increasing this value even higher should help improve throughput of the load.
CAUTION:
A high transaction size may slow down the ThoughtSpot system.

Figure: SSIS transaction size field

This is where the transaction size field exists for SSIS. Clicking on the ODBC destination reveals the properties on the right hand side, where the Transaction Size can be found.

See Set up the ODBC Driver for SSIS for more details on setting the transaction size.

  • Was this article helpful?