tencent cloud

Tencent Cloud TCHouse-D

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
Contact Us
Glossary
Product Policy
Service Level Agreement
Privacy Policy
Data Processing And Security Agreement
ドキュメントTencent Cloud TCHouse-DPerformance TestingSSB Performance TestingTest Results for Reference

Test Results for Reference

PDF
フォーカスモード
フォントサイズ
最終更新日: 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



前の記事へ: Test Scheme Introduction次の記事へ: Testing Scheme Introduction

ヘルプとサポート

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

フィードバック