private void setPreparedStatementParams(final PreparedStatement preparedStatement,
                                            final SQLStatValSourceDO item,
                                            final int iterationZeroBased) throws SQLException {
        int idx = iterationZeroBased * 5;
        preparedStatement.setLong(++idx, item.getCreateMs());
        preparedStatement.setString(++idx, item.getName());
        preparedStatement.setByte(++idx, item.getType().getPrimitiveValue());
        preparedStatement.setDouble(++idx, item.getValueSum().orElse(0));
        preparedStatement.setLong(++idx, item.getCount());
    }
Insert the batch using individual statements, but sent over the network as a batch.
MySQL will execute each one individually unless the MySQL prop 'rewriteBatchedStatements'
is set to on/1, thus it is 10-20x slower than the single statement approaches.

@param batch
@throws SQLException
stroom-statistics/stroom-statistics-impl-sql/src/main/java/stroom/statistics/impl/sql/SQLStatisticValueBatchSaveService.java