Setting EnableStreamingBatchInsert

If you are connecting to a database that is running Vertica Release 8.1.x, for best performance, you should always implement EnableStreamingBatchInsert.

If you are running an earlier version of Vertica, setting EnableStreamingBatchInsert has no impact on performance.

Find the full procedure for accessing the setting in the section, Configuring Your Workflow Connections. For a workflow that is already set up:

  1. While in Workflow Manager, select a task.
  2. From the Connections list box, select Relational.
  3. Click Edit.
  4. In the Connection Object Definition dialog box, check off EnableStreamingBatchInsert.
  5. Click OK. Save your work.
Important: To take advantage of increased performance of EnableStreamingBatchInsert, you must set Copy Local Method to None.