compare speed

[bbq]

I want to choose the fastest:

Code:

1. PreparedStatement stmt = con.prepareStatement(
"INSERT INTO pupils VALUES (?, ?)");
stmt.setInt(1, 1000);
stmt.setString(2, "Edward Brown");
stmt.addBatch();

stmt.setInt(1, 3000);
stmt.setString(2, "Beto Fri");
stmt.addBatch();

// submit the batch for execution
int[] updateCounts = stmt.executeBatch();

2.

Code:

PreparedStatement stmt = con.prepareStatement(
"INSERT INTO pupils VALUES (?, ?)");

stmt.setInt(1, 1000);
stmt.setString(2, "Edward Brown");
stmt.executeUpdate();

stmt.setInt(1, 3000);
stmt.setString(2, "Beto Fri");
stmt.executeUpdate();

which one is fast for execution and why?

[Revelation]

well, probably the first because you are adding values to a batch queue and then executing the batch job. Depending on how much more efficient the batch processor is than executing multiple instances of the update command separately which likely has a lot more overhead.