tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud TCHouse-D
    Documentation
    Download PDF

    Test Results for Reference

    Last updated: 2024-07-31 09:19:42
    Download PDF
      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
      
      
      
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy