xzj7019 commented on code in PR #1493: URL: https://github.com/apache/doris-website/pull/1493#discussion_r1877479049
########## benchmark/tpcds.md: ########## @@ -92,110 +92,111 @@ TPC-DS 99 test query statements : [TPC-DS-Query-SQL](https://github.com/apache/d ## 5. Test Results -Here we use Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: - -| Query | Apache Doris 2.1.1-rc03 (ms) | Apache Doris 2.0.6 (ms) | -|-----------|-------------------------------|--------------------------| -| query1 | 729 | 914 | -| query2 | 5120 | 4669 | -| query3 | 286 | 285 | -| query4 | 11633 | 35148 | -| query5 | 641 | 22979 | -| query6 | 267 | 1351 | -| query7 | 468 | 517 | -| query8 | 263 | 591 | -| query9 | 4444 | 5430 | -| query10 | 418 | 3341 | -| query11 | 7246 | 23300 | -| query12 | 115 | 105 | -| query13 | 661 | 1719 | -| query14 | 13955 | 33254 | -| query15 | 474 | 1414 | -| query16 | 366 | 402 | -| query17 | 1097 | 2371 | -| query18 | 581 | 760 | -| query19 | 283 | 308 | -| query20 | 137 | 117 | -| query21 | 110 | 94 | -| query22 | 1996 | 2481 | -| query23 | 44826 | 77381 | -| query24 | 9873 | 23910 | -| query25 | 666 | 1021 | -| query26 | 221 | 213 | -| query27 | 490 | 544 | -| query28 | 4089 | 4593 | -| query29 | 768 | 1024 | -| query30 | 313 | 682 | -| query31 | 1847 | 2252 | -| query32 | 71 | 68 | -| query33 | 460 | 539 | -| query34 | 629 | 638 | -| query35 | 1660 | 10505 | -| query36 | 412 | 441 | -| query37 | 94 | 86 | -| query38 | 8804 | 8379 | -| query39 | 606 | 898 | -| query40 | 164 | 190 | -| query41 | 55 | 30 | -| query42 | 115 | 113 | -| query43 | 804 | 1332 | -| query44 | 1509 | 1520 | -| query45 | 1678 | 1306 | -| query46 | 1196 | 2167 | -| query47 | 2812 | 3859 | -| query48 | 559 | 1419 | -| query49 | 646 | 725 | -| query50 | 757 | 1299 | -| query51 | 6380 | 4954 | -| query52 | 128 | 123 | -| query53 | 396 | 391 | -| query54 | 388 | 8212 | -| query55 | 124 | 124 | -| query56 | 360 | 434 | -| query57 | 1811 | 2494 | -| query58 | 304 | 666 | -| query59 | 5758 | 7432 | -| query60 | 474 | 481 | -| query61 | 486 | 536 | -| query62 | 647 | 1082 | -| query63 | 358 | 303 | -| query64 | 3250 | 4968 | -| query65 | 5410 | 5971 | -| query66 | 484 | 603 | -| query67 | 26347 | 34052 | -| query68 | 1422 | 1428 | -| query69 | 654 | 808 | -| query70 | 2285 | 4462 | -| query71 | 650 | 1006 | -| query72 | 4324 | 4717 | -| query73 | 500 | 558 | -| query74 | 6678 | 14127 | -| query75 | 3734 | 6312 | -| query76 | 1835 | 1870 | -| query77 | 382 | 496 | -| query78 | 19923 | 23091 | -| query79 | 3061 | 4090 | -| query80 | 851 | 1559 | -| query81 | 565 | 960 | -| query82 | 242 | 221 | -| query83 | 254 | 415 | -| query84 | 203 | 131 | -| query85 | 364 | 444 | -| query86 | 651 | 931 | -| query87 | 8972 | 8554 | -| query88 | 4095 | 5202 | -| query89 | 508 | 480 | -| query90 | 233 | 322 | -| query91 | 174 | 159 | -| query92 | 62 | 59 | -| query93 | 1601 | 1618 | -| query94 | 297 | 297 | -| query95 | 1240 | 27354 | -| query96 | 508 | 847 | -| query97 | 5449 | 11528 | -| query98 | 382 | 287 | -| query99 | 1410 | 2147 | -| **Total** | **264028** | **487990** | +Here we use Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. +The test results are as follows: (Apache Doris 2.0.16-rc01 q78 q79 failed to execute due to memory issues and was removed when calculating the total sum) Review Comment: "memory issue" better changed to other words, e.g, "lack of latest memory optimization", etc. -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
