As title. Especially the insert performance of SAS JDBC is terrible when I'm writing a JDBC application by Java. What I did was prepare an insert statement, then pass to the JDBC connection (SAS 9.4 IOM driver, driver class com.sas.rio.MVADriver). I observed that SAS treated statement.executeBatch() / statement.execute() the same. Seems batch execution won't have performance gains. Tried to change the fetch size which almost the same. Suspended SAS log helped a little. But it's still very slow. Deeply appreciated if somebody can share the tips for optimizing the SAS JDBC insert. Attached the extraction of java code for discussion. prepare and execute insert statements with SAS JDBC while (rs.next()) { rows++; for (int i = 1; i <= columns.size(); i++) { converter.prepareInsertSql(rs, statement, i); } statement.addBatch(); if ((rows % fetchSize) == 0) { statement.executeBatch(); statement.clearWarnings(); target.commit(); } } statement.executeBatch(); target.commit();
... View more