[jira] [Commented] (KYLIN-5286) Improve QueryConnection.getConnection?
[ https://issues.apache.org/jira/browse/KYLIN-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626223#comment-17626223 ] liyang commented on KYLIN-5286: --- The QueryConnection is a lightweight object by design. That means there is no need to manage its lifecycle. Just create it when needed, and throw it away after it's used. That's the best management (unless we start to see performance issue in it). > Improve QueryConnection.getConnection? > -- > > Key: KYLIN-5286 > URL: https://issues.apache.org/jira/browse/KYLIN-5286 > Project: Kylin > Issue Type: Wish > Components: Query Engine >Affects Versions: v4.0.1 >Reporter: Liu Zhao >Priority: Trivial > Attachments: image-2022-10-29-00-51-39-725.png, > image-2022-10-29-00-52-05-786.png > > > Is it possible to cache connections, similar to BasicDataSouce, etc. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (KYLIN-5286) Improve QueryConnection.getConnection?
[ https://issues.apache.org/jira/browse/KYLIN-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626219#comment-17626219 ] Liu Zhao commented on KYLIN-5286: - [~liyang] Thanks for responding to this.Is very low get a new QueryConnection cost in my env,I want to know if there is a better management connection:D > Improve QueryConnection.getConnection? > -- > > Key: KYLIN-5286 > URL: https://issues.apache.org/jira/browse/KYLIN-5286 > Project: Kylin > Issue Type: Wish > Components: Query Engine >Affects Versions: v4.0.1 >Reporter: Liu Zhao >Priority: Trivial > Attachments: image-2022-10-29-00-51-39-725.png, > image-2022-10-29-00-52-05-786.png > > > Is it possible to cache connections, similar to BasicDataSouce, etc. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (KYLIN-5286) Improve QueryConnection.getConnection?
[ https://issues.apache.org/jira/browse/KYLIN-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626216#comment-17626216 ] liyang commented on KYLIN-5286: --- Technically, cache is always possible, at the cost of designing how to refresh the metadata linked by the connection object. How many 'ms' it takes to get a new QueryConnection in your env? Let's check the potential benefit first. :) > Improve QueryConnection.getConnection? > -- > > Key: KYLIN-5286 > URL: https://issues.apache.org/jira/browse/KYLIN-5286 > Project: Kylin > Issue Type: Wish > Components: Query Engine >Affects Versions: v4.0.1 >Reporter: Liu Zhao >Priority: Trivial > Attachments: image-2022-10-29-00-51-39-725.png, > image-2022-10-29-00-52-05-786.png > > > Is it possible to cache connections, similar to BasicDataSouce, etc. -- This message was sent by Atlassian Jira (v8.20.10#820010)