本文介绍AnalyticDB MySQL、Presto、Spark的性能测试结果。
查询执行时间以秒(s)为单位。
测试样本 | AnalyticDB MySQL | Presto | 执行时间增加倍数 | Spark | 执行时间增加倍数 |
---|---|---|---|---|---|
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 |
总时长(s) | 260.8 | 614.6 | 1.356595092 | 1243.93 | 3.769670245 |

在文档使用中是否遇到以下问题
更多建议
匿名提交