[
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, 1:24 PM:
-----------------------------------------------------------------
||Benchmark|Mode|partCount|tblCount|Cnt|Score|Error|Units||
|MySQL|patched|30|4|100|265.502|± 2.449|ms/op|
|MySQL|patched|300|4|100|497.645|± 6.788|ms/op|
|MySQL|patched|600|4|100|783.228|± 8.720|ms/op|
|MySQL|patched|1200|4|100|1548.145|± 18.028|ms/op|
||Benchmark|Mode|partCount|tblCount|Cnt|Score|Error|Units||
|Oracle|patched|30|4|100|1038.296|± 36.946|ms/op|
|Oracle|patched|300|4|100|2670.009|± 135.603|ms/op|
|Oracle|patched|600|4|100|4657.155|± 280.535|ms/op|
|Oracle|patched|1200|4|100|8740.191|± 322.856|ms/op|
was (Author: dkuzmenko):
||Benchmark|Mode|partCount|tblCount|Cnt|Score|Error|Units||
|MySQL|patched|30|4|100|265.502|± 2.449|ms/op|
|MySQL|patched|300|4|100|497.645|± 6.788|ms/op|
|MySQL|patched|600|4|100|783.228|± 8.720|ms/op|
|MySQL|patched|1200|4|100|1548.145|± 18.028|ms/op|
||Benchmark|Mode|partCount|tblCount|Cnt|Score|Error|Units||
|Oracle|patched|30|4|100|1038.296|± 36.946|ms/op|
|Oracle|patched|300|4|100|2670.009|± 135.603|ms/op|
|Oracle|patched|600|4|100|4657.155|± 280.535|ms/op|
|Oracle|patched|1200|4|100|8740.191|± 322.856|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
>
>
> 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)
