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/23 02:33:40 UTC
Re: [PR] [fix](partial-update) insert only without auto_inc column should not use partial update [doris]
doris-robot commented on PR #38229:
URL: https://github.com/apache/doris/pull/38229#issuecomment-2244136018
<details>
<summary>TPC-H: <b>Total hot run time: 39672 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 d2b6f3586ddd715b9bcd89404ad69a3dbb765475, data reload: false
------ Round 1 ----------------------------------
q1 18085 4484 4374 4374
q2 2462 202 191 191
q3 11420 1196 1064 1064
q4 10626 742 836 742
q5 7802 2689 2684 2684
q6 221 140 141 140
q7 968 610 611 610
q8 9449 2046 2057 2046
q9 8469 6581 6525 6525
q10 8769 3822 3745 3745
q11 459 236 246 236
q12 397 228 224 224
q13 18905 2998 2977 2977
q14 284 238 248 238
q15 527 479 479 479
q16 518 378 374 374
q17 957 644 739 644
q18 8249 7475 7355 7355
q19 2531 1546 1321 1321
q20 688 329 327 327
q21 5171 3096 3989 3096
q22 339 294 280 280
Total cold run time: 117296 ms
Total hot run time: 39672 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4312 4242 4244 4242
q2 376 272 265 265
q3 3016 2810 2784 2784
q4 1895 1606 1634 1606
q5 5322 5309 5352 5309
q6 219 134 135 134
q7 2150 1772 1742 1742
q8 3165 3332 3333 3332
q9 8422 8448 8416 8416
q10 3947 3778 3722 3722
q11 566 524 485 485
q12 777 606 607 606
q13 16426 3012 2977 2977
q14 290 265 275 265
q15 519 487 472 472
q16 476 422 411 411
q17 1744 1487 1477 1477
q18 7643 7594 7261 7261
q19 1665 1464 1518 1464
q20 1974 1795 1782 1782
q21 4822 4766 4773 4766
q22 574 463 519 463
Total cold run time: 70300 ms
Total hot run time: 53981 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