[
https://issues.apache.org/jira/browse/HIVE-23048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17093264#comment-17093264
]
Peter Varga commented on HIVE-23048:
------------------------------------
[~pvary]
Performance test results.
1 client runs 1000 queries (every 5th is an update, every 20th is an insert
every other is a select). Only TxnHandler calls, no underlying data.
Serial mode: 1 thread runs 10 client, parallel mode: 10 thread, one
client/thread.
|| ||Postgres s.||Postgres p.||Mysql s.||Mysql p.||Oracle s.||Oracle p.||Mssql
s.||Mssql p.||
|Before patch (avg of 10000 calls in ms.)
|6.95|17.87|8.85|20.10|9.19|34.95|9.16|45.42|
|After patch (avg of 10000 calls in
ms.)|4.68|11.63|7.60|15.45|5.89|18.41|7.92|30.90|
> Use sequences for TXN_ID generation
> -----------------------------------
>
> Key: HIVE-23048
> URL: https://issues.apache.org/jira/browse/HIVE-23048
> Project: Hive
> Issue Type: Bug
> Reporter: Peter Vary
> Assignee: Peter Varga
> Priority: Major
> Attachments: HIVE-23048.1.patch, HIVE-23048.10.patch,
> HIVE-23048.11.patch, HIVE-23048.12.patch, HIVE-23048.13.patch,
> HIVE-23048.2.patch, HIVE-23048.3.patch, HIVE-23048.4.patch,
> HIVE-23048.5.patch, HIVE-23048.6.patch, HIVE-23048.7.patch,
> HIVE-23048.8.patch, HIVE-23048.9.patch
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
