[
https://issues.apache.org/jira/browse/TRAFODION-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16726366#comment-16726366
]
ASF GitHub Bot commented on TRAFODION-3250:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1764
> it's slow in using preparedstmt cache by jdbc
> ---------------------------------------------
>
> Key: TRAFODION-3250
> URL: https://issues.apache.org/jira/browse/TRAFODION-3250
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-jdbc-t4
> Affects Versions: 2.4
> Reporter: mashengchen
> Assignee: mashengchen
> Priority: Major
> Fix For: 2.4
>
>
> when set maxStatements_ > 0 , it will open preparedstmt cache function. then
> I open trafci 'using timing' function, and do prepare s from select * from
> tbl, it cost much time than i close preparedstmt cache.
> the reason is when get pstmt from cache, it will do a network connection to
> get current schema name, while it has already been cache in local.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
