tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud TCHouse-D
    Documentation
    Download PDF

    Test Results for Reference

    Last updated: 2024-12-25 17:55:16
    Download PDF
      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
      
      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