[
https://issues.apache.org/jira/browse/CALCITE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17370933#comment-17370933
]
Julian Hyde edited comment on CALCITE-2322 at 6/28/21, 11:04 PM:
-----------------------------------------------------------------
Properties are defined in [class
CalciteConnectionProperty|https://github.com/apache/calcite/blob/4bc916619fd286b2c0cc4d5c653c96a68801d74e/core/src/main/java/org/apache/calcite/config/CalciteConnectionProperty.java#L39].
Follow the examples there. CALCITE-2995 is an example change that added a
property.
Also update [JDBC adapter
doc|https://calcite.apache.org/docs/adapter.html#jdbc-connect-string-parameters].
was (Author: julianhyde):
Properties are defined in [class
CalciteConnectionProperty|https://github.com/apache/calcite/blob/4bc916619fd286b2c0cc4d5c653c96a68801d74e/core/src/main/java/org/apache/calcite/config/CalciteConnectionProperty.java#L39].
Follow the examples there. CALCITE-2995 is an example change that added a
property.
> Add fetch size support to connection url and JDBC statement
> -----------------------------------------------------------
>
> Key: CALCITE-2322
> URL: https://issues.apache.org/jira/browse/CALCITE-2322
> Project: Calcite
> Issue Type: Improvement
> Components: avatica, core
> Affects Versions: 1.11.0
> Reporter: Kevin Minder
> Priority: Major
> Time Spent: 50m
> Remaining Estimate: 0h
>
> Currently the remote driver defaults to hard coded fetch size of 100 rows.
> When a connection is operating in HTTP mode having such a small fetch size
> can add enormous overhead. This is especially true if TLS connections are
> used and made worse if each connection flows throw multiple proxies.
> Consider that 100K rows returned 100 rows at a time will make 1K HTTP POST
> requests. One might say that nobody should ever do that but some tools like
> Spotfire may end up doing this.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
