I am thinking about using Batch updates (i.e. stmt.executeBatch() ) but I am not quite understanding the advantages. I read in http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/batchupdates.html
that " ... Sending multiple update statements to the database together as a unit can, in some situations, be much more efficient than sending each update statement separately.
My question(s) is: What do they mean "...in some situations..." batch updates would be efficient? Is there an example of where it would not be efficient to use it?
I am using the standard JDBC-ODBC driver connecting to an access database. Did anyone have any problems that I will encounter?
Thanks for your help in advance.