documentation/Reference/Configuration/Flyway Namespace/Flyway Batch Setting.md
Whether to batch SQL statements when executing them. Batching can save up to 99 percent of network round-trips by sending up to 100 statements at once over the network to the database, instead of sending each statement individually.
This is particularly useful for very large SQL migrations composed of multiple MB or even GB of reference data, as this can dramatically reduce the network overhead.
This is supported for INSERT, UPDATE, DELETE, MERGE, and UPSERT statements. All other statements are automatically executed without batching.
Boolean
false
This can't be set in a config file via Flyway Desktop, although it will be honoured, and it can be configured as an advanced parameter in operations on the Migrations page.
./flyway -batch="true" info
[flyway]
batch = true
flyway.batch=true
FLYWAY_BATCH=true
Flyway.configure()
.batch(true)
.load()
flyway {
batch = true
}
<configuration>
<batch>true</batch>
</configuration>
Suppose you have 1000 statements in a migration, and your communication overhead is 0.1 second. Without batching the migrate process would have a 1000 x 0.1 = 100 second overhead in communication (sending the statements) alone. This is a lot of time. With
batch enabled, 100 statements can be sent at a time, meaning the communication overhead is only incurred 1000/100 = 10 times, resulting in a 10 x 0.1 = 1 second migrate overhead due to communication.