I am not familiar with the JDBC driver, but Phoenix uses Avatica[1]
under the hood. The protobuf documentation does state that it's possible
to control the number of rows returned in each response. See
frame_max_size under the FetchRequest[2] message. This may be something
that you can set in the JDBC driver.
Francis
[1] https://calcite.apache.org/avatica
[2]
https://calcite.apache.org/avatica/docs/protobuf_reference.html#fetchrequest
On 22/05/2018 8:39 AM, Kevin Minder wrote:
It is possible to decrease the chattiness of the Phoenix JDBC driver
operating in HTTP mode?
We've tried using stmt.setFetchSize() but this appears to be ignored.
As it stands new we appear to be getting about 100 rows per POST which
presents a number of throughput issues when the results can be 100,000
rows.
