I try to insert many rows (up to 5000) with ca. 40 Columns into MS Access over the driver sun.jdbc.odbc.JdbcOdbcDriver. Autocommit is false. So to have a better performace I tried to use a PreparedStatement:
PreparedStatement prepUpdate = m_dbAccess.getConnection().prepareStatement("INSERT INTO tb_Clients_History VALUES(?,?...)");
This solution is very slow. So I tried to use prepUpdate.addBatch() but this came circa to the same result. Then I tried only to see how many time it will take, a hard INSERT INTO with all data in my loop and that worked 10 TIMES faster!!! How that? What I do wron in my preparedStatement?