This topic lists results of the performance test on AnalyticDB for MySQL, Presto, and Apache Spark.

The query execution time is measured in seconds.

Test sample AnalyticDB for MySQL Presto Execution time multiplier Apache Spark Execution time multiplier
tpch_sql1 24.1 36.28 0.505394191 62.97 1.612863071
tpch_sql2 1.3 12.25 8.423076923 36.03 26.71538462
tpch_sql3 7.1 19.8 1.788732394 39.12 4.509859155
tpch_sql4 13.7 13.21 -0.035766423 24.14 0.762043796
tpch_sql5 16.3 29.9 0.834355828 116.27 6.133128834
tpch_sql6 0.7 11.61 15.58571429 10.6 14.14285714
tpch_sql7 6.6 57.75 7.75 99.97 14.1469697
tpch_sql8 16.2 31.06 0.917283951 78.8 3.864197531
tpch_sql9 34 48.15 0.416176471 144.65 3.254411765
tpch_sql10 5.5 23.25 3.227272727 52.49 8.543636364
tpch_sql11 2.2 11.11 4.05 36.51 15.59545455
tpch_sql12 3.5 14.79 3.225714286 21.64 5.182857143
tpch_sql13 11.3 15.07 0.333628319 37.1 2.283185841
tpch_sql14 1.3 10.62 7.169230769 19.69 14.14615385
tpch_sql15 2.9 21.68 6.475862069 23.77 7.196551724
tpch_sql16 2.3 6.55 1.847826087 80.7 34.08695652
tpch_sql17 5.4 55.85 9.342592593 116.86 20.64074074
tpch_sql18 67.5 58.41 -0.134666667 89.67 0.328444444
tpch_sql19 3 19.92 5.64 21.89 6.296666667
tpch_sql20 9.4 22.13 1.354255319 37.59 2.99893617
tpch_sql21 22.5 88.81 2.947111111 68.42 2.040888889
tpch_sql22 4 6.4 0.6 25.05 5.2625
Total duration (seconds) 260.8 614.6 1.356595092 1243.93 3.769670245
TPC-H Performance