You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "mashengchen (JIRA)" <ji...@apache.org> on 2018/12/18 02:48:00 UTC

[jira] [Created] (TRAFODION-3250) it's slow in using preparedstmt cache by jdbc

mashengchen created TRAFODION-3250:
--------------------------------------

             Summary: 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
             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)