# Step 3. Generate

Use this step to review the job summary, tune performance settings, and start generating.

{% stepper %}
{% step %}

#### Review the job summary

Review the included and excluded tables.

Double-check privacy coverage before you start based using the PII icon.

<figure><img src="https://1383248054-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FU61B9DqtWCNO3Z30vnjh%2Fuploads%2FcLQx5cmn0CV5kZF42OSQ%2Fimage.png?alt=media&#x26;token=61c1e707-947d-40eb-8ece-d92524943117" alt="Job summary showing included/excluded tables and privacy status"><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Tune generation settings (optional)

Generation settings mainly affect speed, memory usage, and database load.

If you read from a production-like source, prefer smaller batches and fewer connections.

<figure><img src="https://1383248054-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FU61B9DqtWCNO3Z30vnjh%2Fuploads%2FiRnVzte6PAEZXq4xhfyI%2Fimage.png?alt=media&#x26;token=2ad15985-6401-4847-be6f-1e93c9cf210b" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Start generating and monitor the job

Select **Generate**.

If you need logs or performance info, use:

* [Logs and monitoring](https://docs.syntho.ai/deploy-syntho/logs-and-monitoring)
* [Large workloads](https://docs.syntho.ai/overview/get-started/syntho-bootcamp/9.-large-workloads)
  {% endstep %}
  {% endstepper %}

### Job summary and generation settings

The job summary is your final check.

It confirms:

* Which tables are included or excluded.
* Which tables contain sensitive data.
* Whether sensitive columns are protected by generators.

### Advanced generation settings

Batch sizes are defined in **datapoints**, not rows.

Datapoints are calculated as:

`rows × columns`

Example:

`10,000 rows × 100 columns = 1,000,000 datapoints (1M)`

You can tune these settings:

* **Read batch size**\
  The maximum datapoints Syntho reads per batch from each source table.\
  Default: **1M**. Value: integer.\
  Increase it to speed up reads. Memory usage goes up.\
  Decrease it if you see memory pressure or timeouts.
* **Write batch size**\
  The maximum datapoints Syntho inserts per batch into each destination table.\
  Default: **1M**. Value: integer.\
  Increase it to speed up writes. Memory usage goes up.\
  Decrease it if you hit driver limits or large queries fail.
* **Maximum number of connections**\
  The maximum parallel connections used for writing.\
  More connections can speed up large jobs. It can also overload the database.\
  When reading from production-like sources, keep this conservative.

### Troubleshooting

#### SQL parameter limit exceeded

Some database drivers cap the number of parameters per SQL statement.

Large **write batch size** can exceed that cap.

Example error:

```
The SQL contains 16970 parameter markers, but 1000010 parameters were supplied
```

**Fix**

Reduce **Write batch size**.

Start by reducing **1M → 0.5M**.

If it persists, reduce again.

The exact limit depends on your database and driver.