View and adjust generation settings

The final step in the data generation wizard allows you to adjust the Generation settings.

Advanced generation settings

The following advanced settings can be adjusted for your generation job:

• Read batch size: The maximum number of rows per batch to read from each table in the source database. The allowed value is integer (number of rows). The default batch size is 100k. You can increase the value to improve reading speeds, at the costs of a larger memory usage, and vice versa.

• Write batch size: The maximum number of rows per batch to insert in each table in the destination database. The allowed value is integer (number of rows). The default batch size is 100k. You can increase the value to improve writing speeds, at the costs of a larger memory usage, and vice versa.

• Maximum number of connections: The maximum number of connections that can be made to the database during the writing. A higher number can speed up the process as it allows for more parallel operations. However, if you are reading from a production database, this might not be desirable.