> ## Documentation Index
> Fetch the complete documentation index at: https://insightsoftware-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# RowsToFetchPerBlock

<a id="rowstofetchperblock" />

The maximum number of rows to fetch per stream if using the result set streaming API. The maximum number of rows to fetch per page if using pagination.

<Note>
  **Note:** While setting this option with a large value when using the result set streaming API can give you better fetch performance, it can also result in higher memory usage. This can be mitigated if the JDBC application can retrieve the result set from the connector quickly.
</Note>

<table><colgroup><col /><col /><col /></colgroup><thead><tr><th scope="col">Default Value</th><th scope="col">Data Type</th><th scope="col">Required</th></tr></thead><tbody><tr><td><p>`10000` for result set streaming, `1000` for pagination</p></td><td><p>Integer</p></td><td><p>No</p></td></tr></tbody></table>