测试结果

本文介绍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