Disable autocommit to reduce network flow

Generally, to reduce network flow, you should set the SQL_ATTR_AUTOCOMMIT connection attribute to SQL_AUTOCOMMIT_OFF. Each commit request can generate extra network flow.

Set this attribute to SQL_AUTOCOMMIT_ON only if the application that you are writing needs to treat each statement as a single, complete transaction.

Important: SQL_AUTOCOMMIT_ON is the default setting for this attribute, unless it is otherwise specified in the initialization file.