KassieZ commented on code in PR #1512: URL: https://github.com/apache/doris-website/pull/1512#discussion_r1881474802
########## versioned_docs/version-3.0/benchmark/ssb.md: ########## @@ -30,25 +30,24 @@ under the License. This document mainly introduces the performance of Doris on the SSB 1000G test set. -We tested 13 queries on the SSB standard test dataset based on Apache Doris version 2.0.6. +We tested 13 queries on the SSB standard test dataset based on Apache Doris version 2.0.16. Review Comment: 2.0.15.1 ########## versioned_docs/version-3.0/benchmark/ssb.md: ########## @@ -63,46 +62,46 @@ We tested 13 queries on the SSB standard test dataset based on Apache Doris vers ## 4. SSB Flat Test Results -Here we use 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 | Doris 2.0.6 (ms) | -|-------|------------------| -| q1.1 | 86 | -| q1.2 | 31 | -| q1.3 | 87 | -| q2.1 | 1046 | -| q2.2 | 569 | -| q2.3 | 480 | -| q3.1 | 1339 | -| q3.2 | 957 | -| q3.3 | 215 | -| q3.4 | 34 | -| q4.1 | 1569 | -| q4.2 | 174 | -| q4.3 | 109 | -| Total | 6696 | +Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: + +| Query | Doris 2.0.16 (ms) | Review Comment: 2.0.15.1 ########## i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/benchmark/ssb.md: ########## @@ -30,25 +30,24 @@ under the License. 本文档主要介绍 Apache Doris 在 SSB 1000G 测试集上的性能表现。 -在 SSB 标准测试数据集上的 13 个查询上，我们基于 Apache Doris 2.0.6 版本进行了测试。 +在 SSB 标准测试数据集上的 13 个查询上，我们基于 Apache Doris 2.0.16 版本进行了测试。 Review Comment: 2.0.15.1 ########## versioned_docs/version-3.0/benchmark/ssb.md: ########## @@ -63,46 +62,46 @@ We tested 13 queries on the SSB standard test dataset based on Apache Doris vers ## 4. SSB Flat Test Results -Here we use 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 | Doris 2.0.6 (ms) | -|-------|------------------| -| q1.1 | 86 | -| q1.2 | 31 | -| q1.3 | 87 | -| q2.1 | 1046 | -| q2.2 | 569 | -| q2.3 | 480 | -| q3.1 | 1339 | -| q3.2 | 957 | -| q3.3 | 215 | -| q3.4 | 34 | -| q4.1 | 1569 | -| q4.2 | 174 | -| q4.3 | 109 | -| Total | 6696 | +Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: + +| Query | Doris 2.0.16 (ms) | +|-----------|-------------------| +| q1.1 | 80 | +| q1.2 | 10 | +| q1.3 | 110 | +| q2.1 | 1680 | +| q2.2 | 1210 | +| q2.3 | 1060 | +| q3.1 | 2010 | +| q3.2 | 1560 | +| q3.3 | 600 | +| q3.4 | 10 | +| q4.1 | 2380 | +| q4.2 | 190 | +| q4.3 | 120 | +| **Total** | **11020** | ## 5. Standard SSB Test Results -Here we use 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 | Doris 2.0.6 (ms) | -|-------|------------------| -| q1.1 | 332 | -| q1.2 | 86 | -| q1.3 | 80 | -| q2.1 | 985 | -| q2.2 | 844 | -| q2.3 | 768 | -| q3.1 | 2924 | -| q3.2 | 944 | -| q3.3 | 766 | -| q3.4 | 146 | -| q4.1 | 3451 | -| q4.2 | 829 | -| q4.3 | 325 | -| Total | 12480 | +Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: + +| Query | Doris 2.0.16 (ms) | Review Comment: 2.0.15.1 ########## versioned_docs/version-3.0/benchmark/ssb.md: ########## @@ -63,46 +62,46 @@ We tested 13 queries on the SSB standard test dataset based on Apache Doris vers ## 4. SSB Flat Test Results -Here we use 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 | Doris 2.0.6 (ms) | -|-------|------------------| -| q1.1 | 86 | -| q1.2 | 31 | -| q1.3 | 87 | -| q2.1 | 1046 | -| q2.2 | 569 | -| q2.3 | 480 | -| q3.1 | 1339 | -| q3.2 | 957 | -| q3.3 | 215 | -| q3.4 | 34 | -| q4.1 | 1569 | -| q4.2 | 174 | -| q4.3 | 109 | -| Total | 6696 | +Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: + +| Query | Doris 2.0.16 (ms) | +|-----------|-------------------| +| q1.1 | 80 | +| q1.2 | 10 | +| q1.3 | 110 | +| q2.1 | 1680 | +| q2.2 | 1210 | +| q2.3 | 1060 | +| q3.1 | 2010 | +| q3.2 | 1560 | +| q3.3 | 600 | +| q3.4 | 10 | +| q4.1 | 2380 | +| q4.2 | 190 | +| q4.3 | 120 | +| **Total** | **11020** | ## 5. Standard SSB Test Results -Here we use 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 | Doris 2.0.6 (ms) | -|-------|------------------| -| q1.1 | 332 | -| q1.2 | 86 | -| q1.3 | 80 | -| q2.1 | 985 | -| q2.2 | 844 | -| q2.3 | 768 | -| q3.1 | 2924 | -| q3.2 | 944 | -| q3.3 | 766 | -| q3.4 | 146 | -| q4.1 | 3451 | -| q4.2 | 829 | -| q4.3 | 325 | -| Total | 12480 | +Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: Review Comment: 2.0.15.1 ########## versioned_docs/version-3.0/benchmark/ssb.md: ########## @@ -30,25 +30,24 @@ under the License. This document mainly introduces the performance of Doris on the SSB 1000G test set. -We tested 13 queries on the SSB standard test dataset based on Apache Doris version 2.0.6. +We tested 13 queries on the SSB standard test dataset based on Apache Doris version 2.0.16. ## 1. Hardware Environment -| Hardware | Configuration Instructions | -|---------------------|-------------------------------------------| -| Number of mMachines | 4 Tencent Cloud Virtual Machine（1FE，3BEs） | -| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48C | -| Memory | 192G | -| Network | 21Gbps | -| Disk | ESSD Cloud Hard Disk | +| Hardware | Configuration Instructions | +|--------------------|------------------------------------------| +| Number of Machines | 4 Aliyun Virtual Machine (1FE，3BEs) | +| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32C | +| Memory | 128G | +| Disk | Enterprise SSD (PL0) | ## 2. Software Environment - Doris Deployed 3BEs and 1FE -- Kernel Version: Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051) +- Kernel Version: Linux version 5.15.0-101-generic - OS version: Ubuntu 20.04 LTS (Focal Fossa) -- Doris software version: Apache Doris 2.0.6. -- JDK: openjdk version "1.8.0_131" +- Doris software version: Apache Doris 2.0.16-rc01 Review Comment: 2.0.15.1 ########## versioned_docs/version-3.0/benchmark/ssb.md: ########## @@ -63,46 +62,46 @@ We tested 13 queries on the SSB standard test dataset based on Apache Doris vers ## 4. SSB Flat Test Results -Here we use 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 | Doris 2.0.6 (ms) | -|-------|------------------| -| q1.1 | 86 | -| q1.2 | 31 | -| q1.3 | 87 | -| q2.1 | 1046 | -| q2.2 | 569 | -| q2.3 | 480 | -| q3.1 | 1339 | -| q3.2 | 957 | -| q3.3 | 215 | -| q3.4 | 34 | -| q4.1 | 1569 | -| q4.2 | 174 | -| q4.3 | 109 | -| Total | 6696 | +Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use Query Time(ms) as the main performance indicator. The test results are as follows: Review Comment: 2.0.15.1 ########## i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/benchmark/ssb.md: ########## @@ -30,25 +30,24 @@ under the License. 本文档主要介绍 Apache Doris 在 SSB 1000G 测试集上的性能表现。 -在 SSB 标准测试数据集上的 13 个查询上，我们基于 Apache Doris 2.0.6 版本进行了测试。 +在 SSB 标准测试数据集上的 13 个查询上，我们基于 Apache Doris 2.0.16 版本进行了测试。 ## 1. 硬件环境 -| 硬件 | 配置说明 | -|------|--------------------------------------| -| 机器数量 | 4 台腾讯云主机（1 个 FE，3 个 BE） | -| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48 核 | -| 内存 | 192G | -| 网络带宽 | 21Gbps | -| 磁盘 | 高性能云硬盘 | +| 硬件 | 配置说明 | +|------|------------------------------------------| +| 机器数量 | 4 台阿里云主机（1 个 FE，3 个 BE） | +| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32核 | +| 内存 | 128G | +| 磁盘 | 阿里云 ESSD (PL0) | ## 2. 软件环境 - Doris 部署 3BE 1FE -- 内核版本：Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051) +- 内核版本：Linux version 5.15.0-101-generic - 操作系统版本：Ubuntu 20.04 LTS (Focal Fossa) -- Doris 软件版本：Apache Doris 2.0.6 -- JDK：openjdk version "1.8.0_131" +- Doris 软件版本：Apache Doris 2.0.16-rc01 Review Comment: 2.0.15.1 -- 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
