Pagesize
Specifies the maximum number of rows that the provider retrieves from Apache Kafka in a single read operation.
Data Type
int
Default Value
1000
Remarks
The adapter reads messages from Apache Kafka in batches and stores them in memory before returning rows to the result set. Only the first row of each batch requires a network request while subsequent rows are returned directly from the in-memory buffer.
This property controls the maximum number of rows the adapter holds in this buffer at one time. Higher values reduce how often the adapter must request new data, while lower values reduce memory usage.