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 2025/05/20 11:10:24 UTC
Re: [PR] [improvement](bf) Skip memcpy for load bloom filter index [doris]
doris-robot commented on PR #51087:
URL: https://github.com/apache/doris/pull/51087#issuecomment-2893944656
<details>
<summary>TPC-H: <b>Total hot run time: 34175 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 6894481f17de2236566481a112d5d40d34672a60, data reload: false
------ Round 1 ----------------------------------
q1 26350 5890 5172 5172
q2 2091 309 193 193
q3 10364 1255 730 730
q4 10221 998 518 518
q5 7549 2380 2339 2339
q6 188 169 132 132
q7 915 755 647 647
q8 9328 1312 1089 1089
q9 6742 5087 5063 5063
q10 6881 2331 1898 1898
q11 507 296 283 283
q12 351 355 218 218
q13 17778 3742 3094 3094
q14 250 222 210 210
q15 550 486 490 486
q16 432 447 370 370
q17 608 847 393 393
q18 7699 7097 7086 7086
q19 1876 953 584 584
q20 348 342 237 237
q21 3860 3259 2463 2463
q22 1050 999 970 970
Total cold run time: 115938 ms
Total hot run time: 34175 ms
----- Round 2, with runtime_filter_mode=off -----
validate_password_policy NONE NONE 0
version 5.7.99 5.7.99 0
version_comment Doris version doris-0.0.0--5e42a09cc0 Doris version doris-0.0.0--5e42a09cc0 0
wait_timeout 28800 28800 0
workload_group 0
============================================
show table status;
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
revenue0 View NULL NULL -1 0 0 NULL 0 NULL NULL 2023-12-26 18:27:24 NULL NULL utf-8 NULL NULL
partsupp Doris NULL NULL 80000000 56 4534120086 NULL 44625495 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:44:20 NULL utf-8 NULL NULL
part Doris NULL NULL 20000000 37 748811035 NULL 1935627 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:27:57 NULL utf-8 NULL NULL
nation Doris NULL NULL 25 138 3473 NULL 366 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:27:24 NULL utf-8 NULL NULL
customer Doris NULL NULL 15000000 92 1381653732 NULL 4374759 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:27:43 NULL utf-8 NULL NULL
lineitem Doris NULL NULL 600037902 33 19843441616 NULL 61784740 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:38:59 NULL utf-8 NULL NULL
supplier Doris NULL NULL 1000000 87 87519212 NULL 194931 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:27:25 NULL utf-8 NULL NULL
region Doris NULL NULL 5 240 1201 NULL 147 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:27:24 NULL utf-8 NULL NULL
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 5283 5176 5134 5134
q2 239 326 234 234
q3 2155 2687 2326 2326
q4 1363 1817 1532 1532
q5 4557 q6 q7 q8 q9 q10 q11 q12 q13 q14 q15 q16 q17 q18 q19 q20 q21 q22 Total cold run time: 9040 ms
Total hot run time: 9226 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