SSIS Components for Google BigQuery

Build 25.0.9434

StoragePageSize

Specifies the number of rows to buffer per page when executing queries using the Google BigQuery Storage API.

データ型

string

デフォルト値

"10000"

解説

This property applies only when UseStorageAPI is enabled and the query is eligible to run on the Google BigQuery Storage API. It controls how many rows the 本製品 retrieves and buffers from the API in each page.

Larger values typically improve performance by reducing the number of round trips to the API, but will increase memory consumption. Smaller values reduce memory usage but may slow down query execution due to more frequent network calls.

Adjust this value based on your environment’s memory capacity and performance needs. For large, high-throughput queries, increasing the value may help. For resource-constrained systems, consider lowering it.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434