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 2026/03/30 08:54:58 UTC
Re: [PR] [Exec](performance) speed up array element at performance [doris]
doris-robot commented on PR #56880:
URL: https://github.com/apache/doris/pull/56880#issuecomment-4153364828
<details>
<summary>TPC-H: <b>Total hot run time: 26719 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 07d0dd74ec85bdd6db978999886167a436b2f204, data reload: false
------ Round 1 ----------------------------------
orders Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL
============================================
q1 17626 4422 4334 4334
q2 q3 10642 797 517 517
q4 4674 362 254 254
q5 7553 1215 1022 1022
q6 181 173 148 148
q7 788 869 679 679
q8 9731 1440 1319 1319
q9 5249 4753 4702 4702
q10 6329 1936 1649 1649
q11 469 254 243 243
q12 754 581 474 474
q13 18028 2694 1995 1995
q14 232 237 217 217
q15 q16 747 728 668 668
q17 741 870 441 441
q18 5860 5354 5247 5247
q19 1453 986 620 620
q20 558 501 381 381
q21 4500 1879 1510 1510
q22 518 352 299 299
Total cold run time: 96633 ms
Total hot run time: 26719 ms
----- Round 2, with runtime_filter_mode=off -----
orders Doris NULL NULL 150000000 42 6422171781 NULL 22778155 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL
============================================
q1 4903 4713 4716 4713
q2 q3 3880 4377 3888 3888
q4 908 1204 786 786
q5 4062 4346 4374 4346
q6 176 176 144 144
q7 1745 1651 1560 1560
q8 2564 2771 2597 2597
q9 7670 7420 7404 7404
q10 3747 3991 3640 3640
q11 524 474 444 444
q12 515 652 451 451
q13 2488 3043 2068 2068
q14 289 330 286 286
q15 q16 713 767 759 759
q17 1186 1430 1324 1324
q18 7132 6768 6704 6704
q19 877 865 901 865
q20 2081 2134 2074 2074
q21 4037 3624 3306 3306
q22 459 442 393 393
Total cold run time: 49956 ms
Total hot run time: 47752 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