Product Introduction

Overview

Concepts

Cluster Architecture

Strengths

Scenarios

Purchase Guide

Billing Overview

Renewal Instructions

Overdue Policy

Refund Instructions

Configuration Adjustment Billing Instructions

Getting Started

Using Tencent Cloud TCHouse-D Through the Console

Using Tencent Cloud TCHouse-D Through a Client

Operation Guide

Cluster Operation

Monitoring and Alarm Configuration

Account Privilege Management

Data Management

Query Management

Modify Configurations

Node Management

Log Analysis

SQL Studio

Enabling Resource Isolation

Development Guide

Design of Data Table

Importing Data

Exporting Data

Basic Feature

Query Optimization

Ecological Expansion Feature

API Documentation

History

Introduction

API Category

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

Data Types

Error Codes

Cloud Ecosystem

Granting CAM Policies to Sub-accounts

Query Acceleration for Tencent Cloud DLC

Practical Tutorial

Basic Feature Usage

Advanced Features Usage

Resource Specification Selection and Optimization Suggestions

Naming Specifications and Limits to the Database and Data Table

Table Design and Data Import

Query Optimization

Suggested Usage to Avoid

Accessing TCHouse-D via JDBC over the Public Network

Performance Testing

TPC-H Performance Testing

SSB Performance Testing

TPC-DS Performance Testing

FAQs

Common Operational Issues

Common Errors

Glossary

Product Policy

Service Level Agreement

Data Processing And Security Agreement

Test Results for Reference

PDF

フォーカスモード

フォントサイズ

最終更新日: 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
﻿

ヘルプとサポート

この記事はお役に立ちましたか？

営業担当者にお問い合わせいただくかチケットを提出してサポートを求めることができます。

フィードバック

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

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

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

tencent cloud

Tencent Cloud TCHouse-D

Test Results for Reference

About TPC-DS Performance Testing

Test Environment

Hardware Environment

Software Version

Test Results for Reference

Test Data

Performance Test Results

ヘルプとサポート