This repo shows how to execute the 22 TPC-H query statements.
Run docker-compose.yml to start mysql container at port 3307.
Run TpcHBenchmark.main() to perform JMH benchmark testing.
The benchmark compares the performance between SpringJdbc and DoytoQuery.
Here is a performance comparison chart on MacBook Air M2 8GB/256GB:
| Query SN | View | Query | Having |
| Q1 | 1 | 1 | 0 |
| Q2 | 1 | 2 | 0 |
| Q3 | 1 | 1 | 0 |
| Q4 | 1 | 2 | 0 |
| Q5 | 1 | 1 | 0 |
| Q6 | 1 | 1 | 0 |
| Q7 | 2 | 3 | 0 |
| Q8 | 2 | 2 | 0 |
| Q9 | 2 | 2 | 0 |
| Q10 | 1 | 1 | 0 |
| Q11 | 1 | 2 | 1 |
| Q12 | 1 | 1 | 0 |
| Q13 | 2 | 3 | 0 |
| Q14 | 1 | 1 | 0 |
| Q15 | 2 | 1 | 0 |
| Q16 | 1 | 1 | 0 |
| Q17 | 1 | 1 | 0 |
| Q18 | 1 | 1 | 1 |
| Q19 | 1 | 2 | 0 |
| Q20 | 1 | 3 | 0 |
| Q21 | 1 | 2 | 0 |
| Q22 | 2 | 2 | 0 |