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