Performance considerations
- Last Updated: May 26, 2023
- 2 minute read
- DataDirect Connectors
- JDBC
- Google BigQuery 6.0
- Documentation
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.
UseStreamingInsert: The UseStreamingInsert connection
property can be used to improve performance by enabling the driver to use the Google BigQuery
Streaming API for executing batch inserts. When UseStreamingInserts is set to true, the driver uses the Streaming API for insert operations with
the tabledata.insertAll method.