You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2024/07/02 17:07:49 UTC
Re: [PR] [Refactor](timezone) refactor tzdata load to accelerate and unify timezone parsing [doris]
doris-robot commented on PR #37062:
URL: https://github.com/apache/doris/pull/37062#issuecomment-2200170078
<details>
<summary>TPC-H: <b>Total hot run time: 40336 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7c9c6167dc6017019dededa0e9e355ef77a2a831, data reload: false
------ Round 1 ----------------------------------
q1 17603 4373 4315 4315
q2 2007 192 189 189
q3 10446 1260 1116 1116
q4 10206 805 784 784
q5 8408 2823 2816 2816
q6 227 140 139 139
q7 963 589 606 589
q8 9224 2111 2091 2091
q9 8956 6551 6518 6518
q10 8920 3754 3735 3735
q11 442 241 253 241
q12 418 242 236 236
q13 18157 2976 2993 2976
q14 263 233 235 233
q15 534 500 505 500
q16 528 388 381 381
q17 985 661 735 661
q18 8145 7570 7434 7434
q19 6501 1602 1517 1517
q20 702 335 336 335
q21 4999 3195 3213 3195
q22 400 336 335 335
Total cold run time: 119034 ms
Total hot run time: 40336 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4425 4289 4280 4280
q2 397 269 276 269
q3 3011 2736 2675 2675
q4 1947 1577 1677 1577
q5 5315 5310 5296 5296
q6 219 130 130 130
q7 2136 1732 1698 1698
q8 3212 3383 3353 3353
q9 8369 8319 8378 8319
q10 3876 3699 3675 3675
q11 586 498 487 487
q12 808 646 599 599
q13 17416 2990 2997 2990
q14 294 266 270 266
q15 529 480 488 480
q16 482 422 416 416
q17 1789 1480 1453 1453
q18 7655 7530 7580 7530
q19 1697 1497 1615 1497
q20 1994 1794 1773 1773
q21 4962 4615 4725 4615
q22 611 563 541 541
Total cold run time: 71730 ms
Total hot run time: 53919 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org