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
|
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.
Was this page helpful?