Test Environment and Description

TPC-H is a test set developed by the Transaction Processing Performance Council (TPC) to simulate decision-making support applications. Built on the actual production and operation environment, TPC-H simulates the data warehouse of a sales system. It contains eight tables with a data volume that ranges from 1 GB to 3 TB. The benchmark test includes 22 queries. The main evaluation indicator is the response time of each query, that is, the duration from query submission until result returned. The test result can comprehensively reflect the query processing capability of the system.

• Test environment: One Kunpeng server with a container environment of 32 CPUs and 128 GB memory is used.
• Test scenario: Based on 50 GB data (Scalar Factor = 50), the column-store engine is used to store data, and 22 query statements in the TPC-H test are used for the test. Each SQL statement is executed for 10 times to obtain an average delay value as the query delay. The lower the query delay, the better the performance. (Data volume of the main tables: The LINEITEM table contains about 300 million rows, the ORDERS table contains about 75 million rows, and the PARSUPP table contains about 40 million rows.)