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 16:59:24 UTC

Re: [PR] [performance](memtable) do not copy input_block if column matches [doris]

doris-robot commented on PR #35524:
URL: https://github.com/apache/doris/pull/35524#issuecomment-2191622320

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40037 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 95b5095cabae3b70b147b02a7b171add5d2f20bb, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17607	4393	4325	4325
   q2	2016	189	185	185
   q3	10491	1140	1115	1115
   q4	10196	869	903	869
   q5	7455	2676	2668	2668
   q6	219	136	134	134
   q7	938	603	616	603
   q8	9232	2101	2128	2101
   q9	9085	6542	6461	6461
   q10	9045	3797	3723	3723
   q11	446	237	233	233
   q12	435	221	216	216
   q13	17954	2969	2985	2969
   q14	263	225	221	221
   q15	508	483	473	473
   q16	525	369	381	369
   q17	989	728	691	691
   q18	8122	7515	7443	7443
   q19	6841	1516	1392	1392
   q20	650	315	305	305
   q21	4897	3202	3883	3202
   q22	404	339	347	339
   Total cold run time: 118318 ms
   Total hot run time: 40037 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4413	4214	4267	4214
   q2	378	258	273	258
   q3	3040	2959	3021	2959
   q4	1939	1743	1719	1719
   q5	5518	5496	5482	5482
   q6	238	131	128	128
   q7	2311	1904	1827	1827
   q8	3295	3461	3507	3461
   q9	8729	8813	8753	8753
   q10	4164	3692	3834	3692
   q11	597	490	492	490
   q12	792	641	638	638
   q13	17130	3107	3183	3107
   q14	303	276	270	270
   q15	513	491	481	481
   q16	507	447	433	433
   q17	1859	1557	1498	1498
   q18	8252	7979	7889	7889
   q19	1870	1625	1637	1625
   q20	3102	1930	1862	1862
   q21	5125	4911	4765	4765
   q22	685	547	580	547
   Total cold run time: 74760 ms
   Total hot run time: 56098 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