wecharyu commented on PR #5700: URL: https://github.com/apache/hive/pull/5700#issuecomment-2752004970
The index is simple enough (2 columns), I think the write operation would not occupy lock for long time. Here is the `openTxns` benchmark for reference: ```bash - no index Operation Mean Med Min Max Err% openTxns.10 6.07188 6.02161 3.81099 13.9566 30.2951 openTxns.100 10.8020 10.0459 6.05904 29.9688 26.6960 openTxns.10000 28.0985 27.4915 18.8563 56.2814 22.1813 - with index Operation Mean Med Min Max Err% openTxns.10 5.80826 5.98342 3.64658 16.2209 34.8030 openTxns.100 9.47621 8.04049 5.79926 19.9999 35.4419 openTxns.10000 25.5064 24.0800 19.0202 46.0265 20.8510 ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org
