[TRAFODION-3250] it's slow in using preparedstmt cache by jdbc

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4
• Fix Version/s: 2.4
• Component/s: client-jdbc-t4
• Assignee: mashengchen
• Reporter: mashengchen
• Created: 18/Dec/18 02:47
• Updated: 21/Dec/18 01:31

Description

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.

Issue Links

• links to: GitHub Pull Request #1764