[HIVE-23103] Oracle statement batching

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Transactions
• Assignee: Peter Vary
• Reporter: Peter Vary
• Created: 30/Mar/20 09:56
• Updated: 17/Nov/22 08:51
• Resolved: 23/Apr/20 10:23

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.