The JDBC driver for GBase 8s provides IFX_AUTOFREE , a parameter that cuts an extra network round trip when closing statements. If your application explicitly calls ResultSet.close() , the cursor is already freed on the server. With IFX_AUTOFREE enabled, the subsequent Statement.close() skips sending a redundant cursor-release message — saving one round trip per execution. How to Enable It URL parameter : jdbc:gbasedbt-sqli:// : / :IFX_AUTOFREE=1 Properties object : Properties pr = new Propertie
Comment
Sign in to join the discussion.
Loading comments…