# 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="/files/4YGu6SKhC966qbvDilk9" 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="/files/Nn8VsU70f3k6T35KSuMn" 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](/deploy-syntho/logs-and-monitoring.md)
* [Large workloads](/overview/get-started/syntho-bootcamp/9.-large-workloads.md)
  {% 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:

* **Batch size**\
  The maximum datapoints Syntho reads, generates and writes per batch.\
  Default: **1M**. Value: integer.\
  Increase it to speed up reads and writes. Memory usage goes up.\
  Decrease it if you see memory pressure or timeouts.
* **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.
* **Simultaneous read/write**\
  When enabled, the next batch is generated while the previous batch is still being written. Disabling this will make generation slower but uses less memory.

### Troubleshooting

#### SQL parameter limit exceeded

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

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

Example error:

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

**Fix**

Reduce **batch size**.

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

If it persists, reduce again.

The exact limit depends on your database and driver.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.syntho.ai/configure-a-data-generation-job/generation-and-validation/view-and-adjust-generation-settings.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.