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/09/05 05:05:41 UTC
Re: [PR] [feature-WIP](query cache) cache tablets aggregate result, FE part [doris]
doris-robot commented on PR #39670:
URL: https://github.com/apache/doris/pull/39670#issuecomment-2330604954
<details>
<summary>TPC-H: <b>Total hot run time: 38536 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 6b61a2a43ce4e1211f3d89d04f14455dce28cd50, data reload: false
------ Round 1 ----------------------------------
q1 18048 5485 4429 4429
q2 2210 188 185 185
q3 10538 1185 1207 1185
q4 10151 782 822 782
q5 7718 2900 2839 2839
q6 225 139 145 139
q7 964 625 628 625
q8 9325 2133 2055 2055
q9 7043 6552 6495 6495
q10 7011 2238 2235 2235
q11 450 245 250 245
q12 402 237 231 231
q13 18860 3085 3107 3085
q14 294 241 249 241
q15 531 488 496 488
q16 600 513 514 513
q17 1017 725 692 692
q18 7635 6889 7026 6889
q19 1385 989 952 952
q20 685 338 335 335
q21 4036 3039 2885 2885
q22 1123 1014 1011 1011
Total cold run time: 110251 ms
Total hot run time: 38536 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4366 4309 4310 4309
q2 380 293 285 285
q3 2926 2620 2667 2620
q4 1938 1620 1715 1620
q5 5421 5438 5501 5438
q6 231 133 134 133
q7 2126 1740 1718 1718
q8 3216 3399 3384 3384
q9 8488 8470 8447 8447
q10 3445 3211 3165 3165
q11 591 498 500 498
q12 784 610 623 610
q13 11669 3134 3085 3085
q14 299 270 289 270
q15 518 484 488 484
q16 641 571 542 542
q17 1809 1504 1479 1479
q18 7873 7535 7533 7533
q19 1658 1617 1533 1533
q20 2080 1810 1809 1809
q21 5376 5474 5220 5220
q22 1103 1018 1054 1018
Total cold run time: 66938 ms
Total hot run time: 55200 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