Skip to content

Conversation

@morningman
Copy link
Contributor

cherry pick from #41606 #42188

@doris-robot
Copy link

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website.
See Doris Document.

@morningman
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 40329 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 4bbfce10aedf75409337cbb29bb4e48ac75274d3, data reload: false

------ Round 1 ----------------------------------
q1	17676	7461	7327	7327
q2	2068	157	147	147
q3	10750	1096	1168	1096
q4	10552	729	774	729
q5	7734	2853	2700	2700
q6	239	156	150	150
q7	994	649	624	624
q8	9333	1916	1971	1916
q9	6526	6431	6454	6431
q10	6963	2267	2272	2267
q11	435	249	246	246
q12	407	217	215	215
q13	17790	2968	2967	2967
q14	238	214	209	209
q15	553	512	518	512
q16	666	595	608	595
q17	975	601	543	543
q18	7268	6632	6488	6488
q19	1578	900	933	900
q20	581	274	270	270
q21	4008	3116	3021	3021
q22	1072	999	976	976
Total cold run time: 108406 ms
Total hot run time: 40329 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7297	7256	7248	7248
q2	324	234	224	224
q3	2888	2879	2858	2858
q4	2055	1836	1838	1836
q5	5708	5665	5704	5665
q6	230	149	143	143
q7	2212	1774	1782	1774
q8	3337	3503	3513	3503
q9	8691	8879	8798	8798
q10	3548	3474	3513	3474
q11	576	490	508	490
q12	823	605	595	595
q13	16432	3194	3111	3111
q14	318	287	275	275
q15	579	530	508	508
q16	725	679	664	664
q17	1856	1619	1587	1587
q18	8220	7847	7626	7626
q19	5424	1554	1462	1462
q20	2083	1890	1849	1849
q21	5383	5280	5159	5159
q22	1109	1048	1032	1032
Total cold run time: 79818 ms
Total hot run time: 59881 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 194154 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 4bbfce10aedf75409337cbb29bb4e48ac75274d3, data reload: false

query1	1253	886	865	865
query2	6266	2114	2080	2080
query3	10775	3754	3736	3736
query4	62915	28344	23533	23533
query5	5095	478	466	466
query6	404	184	169	169
query7	5329	313	311	311
query8	303	202	203	202
query9	7947	2710	2682	2682
query10	446	295	276	276
query11	16536	15136	15529	15136
query12	151	103	106	103
query13	1337	486	476	476
query14	10452	7324	7505	7324
query15	215	177	175	175
query16	7028	517	469	469
query17	1172	557	573	557
query18	1575	291	296	291
query19	214	141	143	141
query20	118	105	109	105
query21	212	100	107	100
query22	4536	4297	4614	4297
query23	34875	33948	33814	33814
query24	6009	2898	2838	2838
query25	495	383	375	375
query26	639	157	166	157
query27	1611	289	290	289
query28	4149	2504	2477	2477
query29	652	415	414	414
query30	230	159	154	154
query31	989	778	800	778
query32	75	52	58	52
query33	441	293	288	288
query34	894	504	507	504
query35	854	724	723	723
query36	1099	929	920	920
query37	147	87	87	87
query38	4079	3923	3933	3923
query39	1465	1421	1414	1414
query40	207	100	100	100
query41	46	43	44	43
query42	123	95	97	95
query43	537	500	495	495
query44	1152	782	782	782
query45	194	165	164	164
query46	1149	708	703	703
query47	1880	1801	1785	1785
query48	437	356	344	344
query49	685	399	372	372
query50	803	411	412	411
query51	7269	6868	6883	6868
query52	106	86	88	86
query53	264	194	190	190
query54	578	487	472	472
query55	78	78	76	76
query56	282	249	255	249
query57	1268	1170	1129	1129
query58	231	231	251	231
query59	3114	2819	2820	2819
query60	294	272	282	272
query61	122	125	146	125
query62	785	668	665	665
query63	214	184	189	184
query64	1471	625	595	595
query65	3208	3141	3189	3141
query66	602	304	303	303
query67	15923	15259	15115	15115
query68	3608	554	553	553
query69	554	284	282	282
query70	1161	1132	1132	1132
query71	436	268	272	268
query72	6939	3894	3864	3864
query73	764	345	336	336
query74	9987	8905	8881	8881
query75	3652	2661	2647	2647
query76	2973	960	918	918
query77	711	288	284	284
query78	9922	9193	9147	9147
query79	2683	592	585	585
query80	1646	437	448	437
query81	563	238	241	238
query82	776	144	136	136
query83	411	137	135	135
query84	298	82	79	79
query85	1353	291	283	283
query86	424	302	295	295
query87	4433	4247	4197	4197
query88	4280	2410	2439	2410
query89	407	290	286	286
query90	2107	183	187	183
query91	148	104	105	104
query92	59	48	49	48
query93	4321	559	535	535
query94	1086	270	276	270
query95	344	248	247	247
query96	632	286	280	280
query97	3322	3104	3159	3104
query98	223	192	192	192
query99	1580	1283	1295	1283
Total cold run time: 317807 ms
Total hot run time: 194154 ms

@morningman morningman merged commit fbd6f01 into apache:branch-3.0 Oct 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants