Test Environment and Description

TPC-H is a benchmark suite developed by the Transaction Processing Performance Council (TPC) to simulate decision-making support applications. Modeled on real-world production environments, TPC-H simulates a sales data warehouse. It consists of eight tables, with configurable data volumes ranging from 1 GB to 3 TB. The benchmark includes 22 queries, with the primary performance metric being the response time of each query, that is, the duration from query submission to result delivery. The test results provide a comprehensive measure of a system's query processing capability.

• 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.)