Programming
HR
Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries
['View All Posts Lukaseder', 'I Made Jooq']
Java, SQL and jOOQ.
Db2 --- Benchmark Mode Score JDBCFetchSizeBenchmark.fetchSize1 thrpt 0.677 JDBCFetchSizeBenchmark.noFetchSize thrpt 1.000 MySQL ----- Benchmark Mode Score JDBCFetchSizeBenchmark.fetchSize1 thrpt 0.985 JDBCFetchSizeBenchmark.noFetchSize thrpt 1.000 Oracle ------ Benchmark Mode Score JDBCFetchSizeBenchmark.fetchSize1 thrpt 0.485 JDBCFetchSizeBenchmark.noFetchSize thrpt 1.000 PostgreSQL ---------- Benchmark Mode Score JDBCFetchSizeBenchmark.fetchSize1 thrpt 1.000 JDBCFetchSizeBenchmark.noFetchSize thrpt 0.998 SQL Server ---------- Benchmark Mode Score JDBCFetchSizeBenchmark.fetchSize1 thrpt 0.972 JDBCFetchSizeBenchmark.noFetchSize thrpt 1.000 *; import org.openjdk.jmh.infra.Blackhole; @Fork(value = 1) @Warmup(iterations = 3, time = 3) @Measurement(iterations = 7, time = 3) public class…