# Performance Testing on Tens of Billions of Data

## Generate Test Data

Please refer to the performance testing tool [Star Schema Benchmark](/docs/uclickhouse/uclickhouse_test/tool/ssb)

**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|                  |

## UClickhouse Cloud Data Warehouse Performance Test

### **Version 21.8LTS, Standard, 64 cores 256G, RSSD Cloud Disk, 4 Nodes, 2 Replicas**

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

| Test Statement | Time (ms) |
| -------------- | --------- |
| Q1.1           | 36952     |
| Q1.2           | 41520     |
| Q1.3           | 34960     |
| Q2.1           | 605256    |
| Q2.2           | 238595    |
| Q2.3           | 189189    |
| Q3.1           | 300709    |
| Q3.2           | 4950690   |
| Q3.3           | 3112151   |
| Q3.4           | 2731311   |
| Q4.1           | 379555    |
| Q4.2           | 337608    |
| Q4.3           | 338180    |