[
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)
