Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-23103

Oracle statement batching

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Component/s: Transactions
    • Labels:
      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.

        Attachments

        1. HIVE-23103.patch
          12 kB
          Peter Vary
        2. HIVE-23103.02.patch
          5 kB
          Peter Vary
        3. HIVE-23103.03.patch
          5 kB
          Peter Vary
        4. HIVE-23103.04.patch
          5 kB
          Peter Vary
        5. HIVE-23103.05.patch
          5 kB
          Peter Vary
        6. HIVE-23103.06.patch
          5 kB
          Peter Vary
        7. HIVE-23103.07.patch
          5 kB
          Peter Vary
        8. HIVE-23103.08.patch
          5 kB
          Peter Vary
        9. HIVE-23103.09.patch
          5 kB
          Peter Vary
        10. HIVE-23103.10.patch
          10 kB
          Peter Vary
        11. HIVE-23103.11.patch
          10 kB
          Peter Vary
        12. HIVE-23103.12.patch
          10 kB
          Peter Vary
        13. HIVE-23103.12.patch
          10 kB
          Peter Vary
        14. HIVE-23103.12.patch
          10 kB
          Peter Vary

          Activity

            People

            • Assignee:
              pvary Peter Vary
              Reporter:
              pvary Peter Vary
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: