TPC-DS测试结果
DWS 测试了使用存算一体和 存算分离两种部署架构下,TPC-DS 1T规模数据集的开箱查询性能,共99个查询。存算一体查询总耗时为417.84s,存算分离查询总耗时为445.34s。详细结果见下表。
|
TPC-DS查询 /时间(s) |
9.1.0 |
9.1.1.100 |
||
|---|---|---|---|---|
|
- |
存算一体 |
存算分离 |
存算一体 |
存算分离 |
|
Q1 |
0.495 |
0.537 |
0.498 |
0.531 |
|
Q2 |
4.098 |
4.259 |
3.877 |
4.227 |
|
Q3 |
1.224 |
1.397 |
1.137 |
1.393 |
|
Q4 |
134.21 |
118.603 |
32.966 |
32.537 |
|
Q5 |
1.426 |
1.66 |
1.222 |
1.323 |
|
Q6 |
0.759 |
0.762 |
0.744 |
0.575 |
|
Q7 |
1.729 |
2.446 |
1.79 |
2.238 |
|
Q8 |
0.474 |
0.47 |
0.425 |
0.47 |
|
Q9 |
13.166 |
12.471 |
12.228 |
11.984 |
|
Q10 |
0.963 |
1.035 |
0.719 |
0.697 |
|
Q11 |
66.002 |
61.731 |
7.918 |
8.255 |
|
Q12 |
0.135 |
0.133 |
0.132 |
0.144 |
|
Q13 |
3.717 |
4.176 |
3.901 |
4.308 |
|
Q14 |
18.118 |
19.244 |
17.14 |
19.311 |
|
Q15 |
0.441 |
0.457 |
0.636 |
0.65 |
|
Q16 |
3.828 |
3.763 |
0.648 |
0.648 |
|
Q17 |
2.298 |
1.456 |
2.698 |
1.573 |
|
Q18 |
1.571 |
1.868 |
1.382 |
1.978 |
|
Q19 |
0.712 |
0.781 |
0.709 |
0.755 |
|
Q20 |
0.105 |
0.092 |
0.087 |
0.087 |
|
Q21 |
0.08 |
0.082 |
0.073 |
0.074 |
|
Q22 |
1.046 |
1.458 |
1.025 |
1.246 |
|
Q23 |
98.08 |
94.936 |
49.471 |
54.571 |
|
Q24 |
9.076 |
9.581 |
9.937 |
10.422 |
|
Q25 |
1.261 |
1.375 |
1.333 |
1.409 |
|
Q26 |
0.535 |
0.725 |
0.437 |
0.449 |
|
Q27 |
1.941 |
2.44 |
1.87 |
2.401 |
|
Q28 |
6.501 |
6.962 |
6.615 |
6.867 |
|
Q29 |
2.175 |
2.464 |
1.793 |
2.71 |
|
Q30 |
0.401 |
0.393 |
0.404 |
0.366 |
|
Q31 |
3.094 |
3.227 |
3.285 |
3.462 |
|
Q32 |
0.092 |
0.088 |
0.072 |
1.02 |
|
Q33 |
0.926 |
0.905 |
0.925 |
0.975 |
|
Q34 |
2.794 |
3.13 |
2.557 |
2.938 |
|
Q35 |
2.352 |
2.62 |
2.857 |
2.406 |
|
Q36 |
1.815 |
2.156 |
1.706 |
1.989 |
|
Q37 |
0.323 |
0.361 |
0.347 |
0.303 |
|
Q38 |
10.249 |
17.642 |
12.393 |
15.065 |
|
Q39 |
5.188 |
5.971 |
5.077 |
5.628 |
|
Q40 |
0.124 |
0.105 |
0.103 |
0.092 |
|
Q41 |
0.032 |
0.036 |
0.039 |
0.036 |
|
Q42 |
0.594 |
0.639 |
0.355 |
0.448 |
|
Q43 |
1.336 |
1.436 |
1.188 |
1.283 |
|
Q44 |
2.192 |
2.324 |
2.154 |
2.337 |
|
Q45 |
0.741 |
0.392 |
1.184 |
0.964 |
|
Q46 |
3.717 |
4.505 |
4.044 |
4.767 |
|
Q47 |
4.623 |
5.435 |
4.654 |
5.433 |
|
Q48 |
3.438 |
3.947 |
3.225 |
3.553 |
|
Q49 |
2.369 |
2.513 |
3.218 |
3.649 |
|
Q50 |
3.82 |
4.508 |
3.618 |
4.327 |
|
Q51 |
4.453 |
5.22 |
4.196 |
4.79 |
|
Q52 |
0.614 |
0.676 |
0.411 |
0.439 |
|
Q53 |
0.696 |
0.779 |
0.737 |
0.732 |
|
Q54 |
0.813 |
1.989 |
4.091 |
3.051 |
|
Q55 |
0.575 |
0.634 |
0.368 |
0.351 |
|
Q56 |
0.716 |
0.793 |
0.701 |
0.792 |
|
Q57 |
1.616 |
1.848 |
1.631 |
1.826 |
|
Q58 |
0.505 |
0.453 |
0.478 |
0.64 |
|
Q59 |
9.106 |
9.012 |
8.87 |
9.401 |
|
Q60 |
1.03 |
1.276 |
1.12 |
1.183 |
|
Q61 |
0.997 |
1.031 |
0.979 |
0.888 |
|
Q62 |
0.758 |
0.886 |
0.746 |
0.758 |
|
Q63 |
0.709 |
0.784 |
0.706 |
0.724 |
|
Q64 |
6.501 |
6.513 |
14.638 |
8.058 |
|
Q65 |
3.576 |
3.484 |
2.965 |
3.649 |
|
Q66 |
1.066 |
1.108 |
1.031 |
1.033 |
|
Q67 |
54.072 |
55.735 |
57.879 |
61.84 |
|
Q68 |
2.935 |
3.493 |
3.152 |
3.673 |
|
Q69 |
0.674 |
0.9 |
0.895 |
0.766 |
|
Q70 |
3.033 |
3.255 |
2.884 |
3.018 |
|
Q71 |
2.046 |
2.101 |
2.197 |
2.005 |
|
Q72 |
2.559 |
2.745 |
2.539 |
2.686 |
|
Q73 |
1.777 |
2.197 |
1.885 |
2.486 |
|
Q74 |
31.74 |
29.214 |
6.703 |
6.548 |
|
Q75 |
6.259 |
5.922 |
6.457 |
6.373 |
|
Q76 |
2.388 |
2.86 |
2.805 |
2.902 |
|
Q77 |
1.142 |
1.306 |
1.054 |
1.108 |
|
Q78 |
11.931 |
12.695 |
12.077 |
12.586 |
|
Q79 |
4.2 |
4.541 |
4.511 |
4.789 |
|
Q80 |
1.659 |
1.848 |
1.528 |
1.621 |
|
Q81 |
0.374 |
0.393 |
0.322 |
0.659 |
|
Q82 |
0.619 |
0.657 |
0.701 |
0.707 |
|
Q83 |
0.083 |
0.173 |
0.088 |
0.194 |
|
Q84 |
0.416 |
0.425 |
0.201 |
0.261 |
|
Q85 |
1.177 |
1.803 |
1.023 |
1.326 |
|
Q86 |
0.35 |
0.38 |
0.328 |
0.39 |
|
Q87 |
10.879 |
18.168 |
11.613 |
16.286 |
|
Q88 |
9.09 |
9.643 |
11.071 |
11.746 |
|
Q89 |
0.971 |
1.035 |
0.887 |
0.956 |
|
Q90 |
0.763 |
0.858 |
0.745 |
0.722 |
|
Q91 |
0.147 |
0.109 |
0.14 |
0.304 |
|
Q92 |
0.117 |
0.132 |
0.109 |
0.131 |
|
Q93 |
3.973 |
5.176 |
3.768 |
4.44 |
|
Q94 |
2.134 |
2.385 |
1.077 |
2.358 |
|
Q95 |
32.74 |
28.579 |
10.887 |
10.968 |
|
Q96 |
1.788 |
2.102 |
2.02 |
2.191 |
|
Q97 |
3.452 |
4.097 |
3.486 |
3.925 |
|
Q98 |
0.828 |
0.826 |
0.871 |
0.8 |
|
Q99 |
1.634 |
1.704 |
1.449 |
1.388 |
|
总时长(s) |
658.067 |
663.64 |
417.836 |
445.342 |