[ https://issues.apache.org/jira/browse/HIVE-23032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17067634#comment-17067634 ]
Denys Kuzmenko edited comment on HIVE-23032 at 3/26/20, 6:29 PM: ----------------------------------------------------------------- MySQL ||Mode|partCount|tblCount|Cnt|Score|Error|Units|| |original|30|4|100|251.485|± 5.201|ms/op| |patched|30|4|100|261.323|± 4.767|ms/op| |original|300|4|100|327.434|± 6.124|ms/op| |patched|300|4|100|338.376|± 3.474|ms/op| |original|600|4|100|472.850|± 9.435|ms/op| |patched|600|4|100|515.727|± 12.683|ms/op| |original|1200|4|100|726.753|± 41.900|ms/op| |patched|1200|4|100|752.484|± 19.530|ms/op| Oracle ||Mode|partCount|tblCount|Cnt|Score|Error|Units|| |original|30|4|100|775.042|± 60.616|ms/op| |patched|30|4|100|434.803|± 38.732|ms/op| |original|300|4|100|11539.710|± 580.909|ms/op| |patched|300|4|100|870.643|± 32.118|ms/op| |original|600|4|100|22671.069|± 949.307|ms/op| |patched|600|4|100|1443.972|± 110.546|ms/op| |original|1200|4|100|47114.679|± 1577.975|ms/op| |patched|1200|4|100|2499.806|± 100.270|ms/op| Postgres ||Mode|partCount|tblCount|Cnt|Score|Error|Units|| |original|30|4|100|310.203|± 10.585|ms/op| |patched|30|4|100|281.426|± 2.209|ms/op| |original|300|4|100|453.817|± 11.402|ms/op| |patched|300|4|100|320.018|± 6.612|ms/op| |original|600|4|100|1148.439|± 120.601|ms/op| |patched|600|4|100|445.005|± 22.069|ms/op| |original|1200|4|100|1366.978|± 380.341|ms/op| |patched|1200|4|100|662.381|± 16.256|ms/op| was (Author: dkuzmenko): MySQL ||Mode|partCount|tblCount|Cnt|Score|Error|Units|| |original|30|4|100|251.485|± 5.201|ms/op| |patched|30|4|100|261.323|± 4.767|ms/op| |original|300|4|100|327.434|± 6.124|ms/op| |patched|300|4|100|338.376|± 3.474|ms/op| |original|600|4|100|472.850|± 9.435|ms/op| |patched|600|4|100|515.727|± 12.683|ms/op| |original|1200|4|100|726.753|± 41.900|ms/op| |patched|1200|4|100|752.484|± 19.530|ms/op| Oracle ||Mode|partCount|tblCount|Cnt|Score|Error|Units|| |original|30|4|100|775.042|± 60.616|ms/op| |patched|30|4|100|434.803|± 38.732|ms/op| |original|300|4|100|11539.710|± 580.909|ms/op| |patched|300|4|100|870.643|± 32.118|ms/op| |original|600|4|100|22671.069|± 949.307|ms/op| |patched|600|4|100|1443.972|± 110.546|ms/op| |original|1200|4|100|47114.679|± 1577.975|ms/op| |patched|1200|4|100|2499.806|± 100.270|ms/op| Postgres ||Mode|partCount|tblCount|Cnt|Score|Error|Units|| |original|30|4|100|||ms/op| |patched|30|4|100|281.426|± 2.209|ms/op| |original|300|4|100|||ms/op| |patched|300|4|100|320.018|± 6.612|ms/op| |original|600|4|100|||ms/op| |patched|600|4|100|445.005|± 22.069|ms/op| |original|1200|4|100|||ms/op| |patched|1200|4|100|662.381|± 16.256|ms/op| > Add batching in Lock generation > ------------------------------- > > Key: HIVE-23032 > URL: https://issues.apache.org/jira/browse/HIVE-23032 > Project: Hive > Issue Type: Improvement > Components: Locking > Reporter: Denys Kuzmenko > Assignee: Denys Kuzmenko > Priority: Major > Attachments: HIVE-23032.1.patch, HIVE-23032.2.patch, > HIVE-23032.3.patch, HIVE-23032.4.patch, HIVE-23032.5.patch, > HIVE-23032.6.patch, HIVE-23032.7.patch, HIVE-23032.8.patch > > > Replace multi-row insert in Oracle with batching. Performance tests showed > significant performance improvement after turning batching on. -- This message was sent by Atlassian Jira (v8.3.4#803005)