Performance considerations
- Last Updated: December 17, 2020
- 1 minute read
The following connection properties can enhance driver performance.
FetchSize/WSFetchSize: The connection properties FetchSize and WSFetchSize can be used to adjust the trade-off between throughput and response time. In general, setting larger values for WSFetchSize and FetchSize will improve throughput, but can reduce response time.
UseStorageAPI: The UseStorageAPI connection property
can be used to improve performance by enabling the driver to use the Google BigQuery Storage
API when fetching large result sets. When UseStorageAPI is set to true, the driver uses the Storage API for selects when the number of rows in the
result set exceeds the value of the StorageAPIThreshold property, and the number of pages in
the result set exceeds the value of the StorageAPIMinPageCount property.