Performance Testing on Tens of Billions of Data

Generate Test Data

Please refer to the performance testing tool Star Schema Benchmark

Data generation as follows:

Table Name	Number of Rows	Size	Description
lineorder	105 billion (104999988705)	12T	Order table
customer	525 million (525000000)	56G	Customer table
part	100 million (109375000)	11G	Parts table
supplier	35 million (35000000)	3.3G	Supplier table
date	2556	144M	Date table
Total	1056,6936,6261	12.07T

The following data results are based on the multi-table testing conducted with the Star Schema Benchmark tool.