Tencent Cloud TCHouse-D
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Monitoring and Alarm Configuration
- Account Privilege Management
- Data Management
- Query Management
- Modify Configurations
- Development Guide
- Design of Data Table
- Importing Data
- Import Methods
- Exporting Data
- Basic Feature
- Query Optimization
- API Documentation
- Making API Requests
- Cluster Operation APIs
- Database and Table APIs
- Cluster Information Viewing APIs
- Hot-Cold Data Layering APIs
- Database and Operation Audit APIs
- User and Permission APIs
- Resource Group Management APIs
- Practical Tutorial
- Performance Testing
- TPC-H Performance Testing
- SSB Performance Testing
DocumentationTencent Cloud TCHouse-DPerformance TestingSSB Performance TestingTest Results for Reference
Test Results for Reference
Last updated: 2025-01-07 11:19:57
This document will provide a reference for the results of performance testing of Tencent Cloud TCHouse-D using SSB.
About SSB Performance Test
SSB (Star Schema Benchmark) is a lightweight performance test set for data warehouse scenes. SSB provides a simplified star model data set based on TPC-H, which is mainly used to test the performance of multi-table join queries under the star model. In addition, the industry practice is to flatten SSB into a wide table model (hereinafter referred to as: SSB FLAT) to test the performance of the query engine.
Test Environment
Hardware Environment
In this document, two model clusters are tested, each containing 1 FE and 3 BEs. The FE/BE node processes are deployed separately. It should be noted that the principle for selecting a cluster of models is to be close to common user configurations, and in actual testing, such a large amount of hardware resources will not be consumed.
Cluster Specifications | Node Type | Specification |
Specification 1 (small and medium-sized data scenes) | 1 FE | CPU:4 cores Memory: 16 GB Hard disk: Enhanced SSD Cloud Disk 200 GB |
| 3 BEs | CPU:16 cores Memory: 64 GB Hard disk: Enhanced SSD Cloud Disk 1500 GB |
Specification 2 (large-scale data scenes) | 1 FE | CPU:16 cores Memory: 64 GB Hard disk: Enhanced SSD Cloud Disk 200 GB |
| 3 BEs | CPU:64 cores Memory: 256 GB Hard disk: Enhanced SSD Cloud Disk 1500 GB |
Software Version
Tencent Cloud TCHouse-D 1.2.7
Test Results for Reference
Test Data
The test is conducted using two data sets, Scale 100 and Scale 1000. The descriptions and data volume of the created tables are as follows:
SSB Table Name | Number of Rows - Scale 100 | Number of Rows - Scale 1000 | Remarks |
LINEORDER | 600,037,902 | 5,999,989,709 | Product Order Details Table |
CUSTOMER | 3,000,000 | 30,000,000 | Customer Information Table |
PART | 1,400,000 | 2,000,000 | Parts Information Table |
SUPPLIER | 200,000 | 2,000,000 | Supplier Information Table |
DATE | 2,556 | 2,556 | Date Table |
Performance Test Results
Note:
The test result is the average time of three queries of the corresponding SQL file, in seconds (s).
SSB Test Results
Query Number | Specification 1-Scale 100 Data Set | Specification 2-Scale 100 Data Set | Specification 1-Scale 1000 Data Set | Specification 2-Scale 1000 Data Set |
Q1.1 | 0.05 | 0.04 | 0.27 | 0.26 |
Q1.2 | 0.03 | 0.03 | 0.14 | 0.13 |
Q1.3 | 0.03 | 0.03 | 0.13 | 0.13 |
Q2.1 | 0.33 | 0.15 | 5.32 | 1.29 |
Q2.2 | 0.27 | 0.12 | 4.89 | 1.19 |
Q2.3 | 0.26 | 0.12 | 4.67 | 1.14 |
Q3.1 | 0.53 | 0.39 | 9.52 | 7.27 |
Q3.2 | 0.23 | 0.12 | 4.33 | 1.06 |
Q3.3 | 0.30 | 0.12 | 3.58 | 0.71 |
Q3.4 | 0.06 | 0.05 | 0.34 | 0.24 |
Q4.1 | 0.73 | 0.41 | 10.84 | 5.59 |
Q4.2 | 0.38 | 0.34 | 4.15 | 2.56 |
Q4.3 | 0.47 | 0.54 | 4.37 | 4.22 |
Total time | 3.66 | 2.43 | 52.54 | 25.79 |
SSB FLAT Test Results
Query Number | Specification 1-Scale 100 Data Set | Specification 2-Scale 100 Data Set | Specification 1-Scale 1000 Data Set | Specification 2-Scale 1000 Data Set |
Q1.1 | 0.03 | 0.02 | 0.13 | 0.10 |
Q1.2 | 0.01 | 0.01 | 0.02 | 0.02 |
Q1.3 | 0.03 | 0.04 | 0.23 | 0.22 |
Q2.1 | 0.08 | 0.05 | 3.61 | 1.04 |
Q2.2 | 0.08 | 0.05 | 2.86 | 0.37 |
Q2.3 | 0.06 | 0.04 | 2.54 | 0.28 |
Q3.1 | 0.15 | 0.09 | 4.30 | 1.50 |
Q3.2 | 0.08 | 0.05 | 3.45 | 1.09 |
Q3.3 | 0.07 | 0.04 | 1.93 | 0.26 |
Q3.4 | 0.01 | 0.02 | 0.03 | 0.02 |
Q4.1 | 0.13 | 0.08 | 4.96 | 2.22 |
Q4.2 | 0.05 | 0.04 | 1.59 | 0.23 |
Q4.3 | 0.03 | 0.03 | 1.23 | 0.14 |
Total time | 0.82 | 0.54 | 26.87 | 7.49 |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No