Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Examine how to really get better performance for oracle statement batches.
Oracle JDBC doc describes:
The Oracle implementation of standard update batching does not implement true batching for generic statements and callable statements. Even though Oracle JDBC supports the use of standard batching for Statement and CallableStatement objects, you are unlikely to see performance improvement.
I would look for connection properties to set, so it is handled anyway, or if not, then use:
begin query1; query2; query3; end;
to we will have only a single roundtrip for the db.