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
Test Results for Reference
Last updated: 2024-12-25 17:55:16
This document provides a reference for the results of performance testing for TCHouse-D using TPC-DS.
About TPC-DS Performance Testing
TPC-DS is a benchmark test with a focus on decision-making support, designed to evaluate the performance of data warehouses and analytical systems. Developed by the TPC (Transaction Processing Performance Council), it is used to compare different systems' capabilities in handling complex inquiries and large-scale data analysis.
The design goal of TPC-DS is to simulate complex decision-making support workloads found in real-world scenarios. It tests system performance through a series of complex inquiries and data operations, including joins, aggregations, sorts, filters, sub-inquiries, and more. These inquiry patterns cover a range of simple and complex scenarios, such as report generation, data mining, and OLAP (online analytical processing).
Test Environment
Hardware Environment
In the reference scheme provided in this document, the tested cluster consists of 3 FEs and 3 BEs, with the FE and BE node processes deployed separately. The specific specifications are shown below. Please note that in actual testing, such an extensive amount of hardware resources would not be consumed.
Node Type | Node Specifications |
3 FEs, standard | CPU: 16 cores Memory: 64 GB Hard disk: Enhanced SSD 200 GB |
3 BEs, standard | CPU: 16 cores Memory: 64 GB Hard disk: Enhanced SSD 1000 GB |
Software Version
Tencent Cloud TChouse-D 2.1.7
Test Results for Reference
Test Data
Table Name | Original Text File Size | Size After Importing 100 G | Number of Buckets | Number of Rows |
call_center | 9.2 KiB | 13.784 KB | 1 | 30 |
catalog_page | 2.8 MiB | 1.216 MB | 3 | 20400 |
catalog_returns | 2.2 GiB | 736.137 MB | 32 | 14404374 |
catalog_sales | 29 GiB | 9.225 GB | 960 | 143997065 |
customer | 256 MiB | 111.185 MB | 12 | 2000000 |
customer_address | 106 MiB | 21.386 MB | 12 | 1000000 |
customer_demographics | 76 MiB | 6.468 MB | 12 | 1920800 |
date_dim | 9.8 MiB | 1.823 MB | 12 | 73049 |
dbgen_version | 111 B | 1.184 KB | 1 | 1 |
household_demographics | 142 KiB | 20.372 KB | 3 | 7200 |
income_band | 308 B | 724.000 B | 1 | 20 |
inventory | 7.7 GiB | 871.378 MB | 32 | 399330000 |
item | 56 MiB | 25.314 MB | 12 | 204000 |
promotion | 122 KiB | 73.989 KB | 1 | 1000 |
reason | 1.9 KiB | 7.748 KB | 1 | 55 |
ship_mode | 1.1 KiB | 3.251 KB | 1 | 20 |
store | 104 KiB | 54.449 KB | 1 | 402 |
store_returns | 3.3 GiB | 1.090 GB | 32 | 28795080 |
store_sales | 38 GiB | 12.529 GB | 960 | 287997024 |
time_dim | 4.8 MiB | 1.087 MB | 12 | 86400 |
warehouse | 1.8 KiB | 4.999 KB | 1 | 15 |
web_page | 193 KiB | 38.753 KB | 1 | 2040 |
web_returns | 998 MiB | 350.227 MB | 32 | 7197670 |
web_sales | 15 GiB | 4.645 GB | 960 | 72001237 |
web_site | 6.7 KiB | 11.185 KB | 1 | 24 |
Total | 96 G | 29.566 GB | 3096 | 959037906 |
Performance Test Results
Note:
The test result is the average time of three queries of the corresponding SQL file, in seconds.
Query Number | 100 GB data set |
query1 | 0.265 |
query2 | 1.644 |
query3 | 0.156 |
query4 | 3.147 |
query5 | 0.313 |
query6 | 0.171 |
query7 | 0.271 |
query8 | 0.169 |
query9 | 1.893 |
query10 | 0.202 |
query11 | 1.974 |
query12 | 0.087 |
query13 | 0.323 |
query14 | 4.288 |
query15 | 0.16 |
query16 | 0.809 |
query17 | 0.44 |
query18 | 0.343 |
query19 | 0.157 |
query20 | 0.095 |
query21 | 0.093 |
query22 | 3.586 |
query23 | 8.414 |
query24 | 2.067 |
query25 | 0.33 |
query26 | 0.142 |
query27 | 0.255 |
query28 | 1.688 |
query29 | 0.363 |
query30 | 0.138 |
query31 | 0.576 |
query32 | 0.051 |
query33 | 0.248 |
query34 | 0.295 |
query35 | 0.583 |
query36 | 0.287 |
query37 | 0.065 |
query38 | 1.494 |
query39 | 0.85 |
query40 | 0.093 |
query41 | 0.054 |
query42 | 0.088 |
query43 | 0.445 |
query44 | 0.64 |
query45 | 0.177 |
query46 | 0.517 |
query47 | 1.214 |
query48 | 0.264 |
query49 | 0.313 |
query50 | 0.294 |
query51 | 4.325 |
query52 | 0.086 |
query53 | 0.157 |
query54 | 0.4 |
query55 | 0.09 |
query56 | 0.219 |
query57 | 0.863 |
query58 | 0.217 |
query59 | 2.468 |
query60 | 0.255 |
query61 | 0.117 |
query62 | 0.273 |
query63 | 0.14 |
query64 | 1.314 |
query65 | 1.608 |
query66 | 0.239 |
query67 | 11.163 |
query68 | 0.476 |
query69 | 0.226 |
query70 | 1.164 |
query71 | 0.329 |
query72 | 1.853 |
query73 | 0.271 |
query74 | 1.8 |
query75 | 1.347 |
query76 | 0.453 |
query77 | 0.26 |
query78 | 3.484 |
query79 | 1.114 |
query80 | 0.597 |
query81 | 0.188 |
query82 | 0.148 |
query83 | 0.187 |
query84 | 0.078 |
query85 | 0.367 |
query86 | 0.306 |
query87 | 1.738 |
query88 | 1.747 |
query89 | 0.207 |
query90 | 0.109 |
query91 | 0.141 |
query92 | 0.043 |
query93 | 0.034 |
query94 | 0.533 |
query95 | 0.205 |
query96 | 0.242 |
query97 | 1.667 |
query98 | 0.3 |
query99 | 0.493 |
Total Time | 88.572 |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No