Optimizing GBase 8s JDBC with the OPTOFC Parameter

OPTOFC (optimize-OPEN-FETCH-CLOSE) is a JDBC option in GBASE's GBase 8s that reduces network round trips when executing SELECT statements with PreparedStatement . This post explains how it works and demonstrates the real performance gain with benchmarks. When OPTOFC Takes Effect The optimization kicks in only when all of the following are true: The statement is a PreparedStatement instance. The query is a SELECT . The ResultSet type is TYPE_FORWARD_ONLY . The concurrency mode is CONCUR_READ_ONLY