Performance Test Report
Download
Focus Mode
Font Size
This document is the Column Store Index (CSI) performance test report of TDSQL-C for MySQL.
Standard Performance Test Report
Data set: TPC-H.
Tested data volume: 100 GB.
Instance specification: 32 cores and 256 GB of memory.
Query: execution time speedup of Q1, Q3, Q6, Q7, Q8, Q9, Q11, Q12, Q14, Q15, and Q19.
Execution Time
Query | Non-CSI (s) | CSI (s) | Speedup |
Q1 | 1419.89 | 738.03 | 1.92 |
Q3 | 427.04 | 203.61 | 2.10 |
Q6 | 310.66 | 23.72 | 13.10 |
Q7 | 1246.7 | 390.99 | 3.19 |
Q8 | 661.36 | 162.96 | 4.06 |
Q9 | 1800 | 1131.23 | 1.59 |
Q11 | 436.65 | 33.93 | 12.87 |
Q12 | 357.25 | 211.42 | 1.69 |
Q14 | 329.48 | 48.19 | 6.84 |
Q15 | 709.06 | 99.90 | 7.10 |
Q19 | 561.56 | 269.04 | 2.09 |
Execution Time Speedup
Conclusion
CSI can improve the query performance by significantly reducing the time consumed by queries.
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback