tencent cloud

Feedback

Performance Test Report

Last updated: 2023-12-12 14:40:17
    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.
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support