TPC-H Performance Results
Last updated:2025-10-23 20:50:32
This document describes the TPC-H performance test for the "read-only analysis engine" of TDSQL-C for MySQL.
Note:
The performance of read-only analysis engine instances varies according to different instance specifications. Test results in this document are for reference only. For the test method, refer to TPC-H Test Method.
TPC-H
Test Server | Test Data Set (GB) |
M8.8XLARGE256 | 100 |
Total Execution Time of Each Version
Test Version | Total Execution Time (Seconds) |
4.2506.x | 21.1 |
3.2503.x | 26.2 |
2.2410.x | 32.4 |
1.2404.x | 48.8 |
Performance Results
Query SQL | Execution Time (Seconds) |
Q1 | 1.4835 |
Q2 | 0.1367 |
Q3 | 0.97 |
Q4 | 0.7345 |
Q5 | 0.8532 |
Q6 | 0.3157 |
Q7 | 0.9577 |
Q8 | 0.6849 |
Q9 | 3.2775 |
Q10 | 1.5327 |
Q11 | 0.2592 |
Q12 | 0.7715 |
Q13 | 1.5745 |
Q14 | 0.3711 |
Q15 | 0.6806 |
Q16 | 0.3806 |
Q17 | 0.6324 |
Q18 | 2.1682 |
Q19 | 0.4825 |
Q20 | 0.5684 |
Q21 | 2.004 |
Q22 | 0.3257 |
Total | 21.1651 |
Query SQL | Execution Time (Seconds) |
Q1 | 1.6709 |
Q2 | 0.1527 |
Q3 | 1.2515 |
Q4 | 0.9788 |
Q5 | 1.0737 |
Q6 | 0.3049 |
Q7 | 1.1951 |
Q8 | 0.8567 |
Q9 | 4.3268 |
Q10 | 1.5661 |
Q11 | 0.2335 |
Q12 | 0.8178 |
Q13 | 1.9259 |
Q14 | 0.4562 |
Q15 | 0.7116 |
Q16 | 0.3585 |
Q17 | 0.8066 |
Q18 | 2.8576 |
Q19 | 0.6209 |
Q20 | 0.8007 |
Q21 | 2.9172 |
Q22 | 0.3296 |
Total | 26.2133 |
Query SQL | Execution Time (Seconds) |
Q1 | 2.7153 |
Q2 | 0.1833 |
Q3 | 1.725 |
Q4 | 1.279 |
Q5 | 1.3958 |
Q6 | 0.3105 |
Q7 | 1.4588 |
Q8 | 1.1674 |
Q9 | 5.4706 |
Q10 | 1.9342 |
Q11 | 0.3169 |
Q12 | 1.0144 |
Q13 | 2.0232 |
Q14 | 0.54 |
Q15 | 0.7387 |
Q16 | 0.4106 |
Q17 | 0.9051 |
Q18 | 3.078 |
Q19 | 0.8404 |
Q20 | 1.3684 |
Q21 | 3.0853 |
Q22 | 0.444 |
Total | 32.4049 |
Query SQL | Execution Time (Seconds) |
Q1 | 3.66 |
Q2 | 0.39 |
Q3 | 2.37 |
Q4 | 1.53 |
Q5 | 2.91 |
Q6 | 0.74 |
Q7 | 1.99 |
Q8 | 1.6 |
Q9 | 7.8 |
Q10 | 2.81 |
Q11 | 0.42 |
Q12 | 1.79 |
Q13 | 3.32 |
Q14 | 1.12 |
Q15 | 1.2 |
Q16 | 1.18 |
Q17 | 1.42 |
Q18 | 3.62 |
Q19 | 1.74 |
Q20 | 1.64 |
Q21 | 5.04 |
Q22 | 0.51 |
Total | 48.8 |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback