[ 
https://issues.apache.org/jira/browse/HIVE-23104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17083005#comment-17083005
 ] 

Marton Bod commented on HIVE-23104:
-----------------------------------

Performance test results:
|*Variant*|*DBType*|*TxnType*|*Count*|*Result (ms)*|*Error*|
|master|SQLSERVER|READ_ONLY|100|9.273|0.239|
|patched|SQLSERVER|READ_ONLY|100|5.977|0.276|
|master|POSTGRES|READ_ONLY|100|11.977|0.538|
|patched|POSTGRES|READ_ONLY|100|8.342|1.468|
|master|ORACLE|READ_ONLY|100|11.667|0.267|
|patched|ORACLE|READ_ONLY|100|8.316|0.293|
|master|MYSQL|READ_ONLY|100|10.2|0.429|
|patched|MYSQL|READ_ONLY|100|9.689|0.386|
|master|SQLSERVER|DEFAULT|100|9.87|0.337|
|patched|SQLSERVER|DEFAULT|100|8.752|0.123|
|master|POSTGRES|DEFAULT|100|10.105|0.236|
|patched|POSTGRES|DEFAULT|100|11.229|0.171|
|master|ORACLE|DEFAULT|100|12.874|0.64|
|patched|ORACLE|DEFAULT|100|12.114|0.317|
|master|MYSQL|DEFAULT|100|11.309|0.37|
|patched|MYSQL|DEFAULT|100|11.471|0.4|

> Minimize critical paths of TxnHandler::commitTxn and abortTxn
> -------------------------------------------------------------
>
>                 Key: HIVE-23104
>                 URL: https://issues.apache.org/jira/browse/HIVE-23104
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Marton Bod
>            Assignee: Marton Bod
>            Priority: Major
>         Attachments: HIVE-23104.1.patch, HIVE-23104.1.patch, 
> HIVE-23104.1.patch, HIVE-23104.2.patch, HIVE-23104.2.patch, HIVE-23104.3.patch
>
>
> Investigate whether any code sections in TxnHandler::commitTxn and abortTxn 
> can be lifted out/executed async in order to reduce the overall execution 
> time of these methods.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to