TPC-DS测试结果
本测试主要包括使用存算一体和存算分离两种部署架构下，TPC-DS 1T规模数据集的开箱查询性能，共99个查询。存算一体查询总耗时为622.21s，存算分离查询总耗时为645.42s。详细结果见下表。
|
TPC-DS查询 |
8.3.0 |
9.1.0.210 |
|
|---|---|---|---|
|
- |
存算一体（s） |
存算一体（s） |
存算分离（s） |
|
Q1 |
2.03 |
0.513 |
0.546 |
|
Q2 |
9.14 |
4.036 |
4.286 |
|
Q3 |
1.52 |
1.228 |
1.426 |
|
Q4 |
200.44 |
125.877 |
122.118 |
|
Q5 |
3.11 |
1.403 |
1.509 |
|
Q6 |
0.39 |
0.399 |
0.366 |
|
Q7 |
1.85 |
1.665 |
2.227 |
|
Q8 |
0.72 |
0.481 |
0.483 |
|
Q9 |
11.14 |
13.604 |
12.354 |
|
Q10 |
1.08 |
0.711 |
0.876 |
|
Q11 |
92.20 |
62.143 |
63.736 |
|
Q12 |
0.20 |
0.131 |
0.132 |
|
Q13 |
2.50 |
3.502 |
3.853 |
|
Q14 |
74.98 |
17.622 |
18.407 |
|
Q15 |
2.11 |
0.412 |
0.434 |
|
Q16 |
6.51 |
3.148 |
3.256 |
|
Q17 |
2.93 |
1.168 |
2.618 |
|
Q18 |
2.16 |
1.191 |
1.443 |
|
Q19 |
0.70 |
0.665 |
0.771 |
|
Q20 |
0.18 |
0.108 |
0.086 |
|
Q21 |
0.18 |
0.084 |
0.084 |
|
Q22 |
5.84 |
1.089 |
1.286 |
|
Q23 |
144.71 |
85.005 |
90.962 |
|
Q24 |
8.55 |
9.033 |
9.438 |
|
Q25 |
3.10 |
1.262 |
2.580 |
|
Q26 |
0.63 |
0.449 |
0.516 |
|
Q27 |
2.03 |
1.739 |
2.219 |
|
Q28 |
13.32 |
6.293 |
6.623 |
|
Q29 |
2.50 |
2.049 |
2.364 |
|
Q30 |
0.73 |
0.404 |
0.402 |
|
Q31 |
3.73 |
3.045 |
2.902 |
|
Q32 |
0.18 |
0.089 |
0.096 |
|
Q33 |
1.28 |
0.821 |
0.815 |
|
Q34 |
2.13 |
2.653 |
3.011 |
|
Q35 |
3.00 |
2.132 |
1.743 |
|
Q36 |
6.21 |
1.766 |
1.971 |
|
Q37 |
0.34 |
0.231 |
0.268 |
|
Q38 |
52.24 |
10.150 |
11.110 |
|
Q39 |
5.57 |
5.057 |
5.475 |
|
Q40 |
0.66 |
0.128 |
0.126 |
|
Q41 |
0.04 |
0.036 |
0.033 |
|
Q42 |
0.70 |
0.389 |
0.436 |
|
Q43 |
1.99 |
1.256 |
1.410 |
|
Q44 |
3.25 |
2.218 |
2.381 |
|
Q45 |
0.82 |
0.399 |
0.404 |
|
Q46 |
4.63 |
3.569 |
4.154 |
|
Q47 |
6.91 |
4.542 |
5.156 |
|
Q48 |
2.37 |
3.129 |
3.508 |
|
Q49 |
3.01 |
2.291 |
2.478 |
|
Q50 |
5.82 |
3.694 |
4.204 |
|
Q51 |
10.67 |
4.368 |
4.630 |
|
Q52 |
0.70 |
0.384 |
0.457 |
|
Q53 |
0.88 |
0.715 |
0.794 |
|
Q54 |
3.96 |
0.609 |
4.123 |
|
Q55 |
0.66 |
0.402 |
0.421 |
|
Q56 |
0.84 |
0.751 |
0.707 |
|
Q57 |
3.12 |
1.643 |
1.826 |
|
Q58 |
0.76 |
0.548 |
0.449 |
|
Q59 |
17.30 |
8.824 |
9.302 |
|
Q60 |
1.75 |
0.920 |
0.988 |
|
Q61 |
1.10 |
0.980 |
1.013 |
|
Q62 |
1.29 |
0.813 |
0.779 |
|
Q63 |
0.86 |
0.697 |
0.799 |
|
Q64 |
14.20 |
6.504 |
7.643 |
|
Q65 |
6.92 |
3.988 |
3.630 |
|
Q66 |
1.50 |
1.018 |
1.077 |
|
Q67 |
153.90 |
54.645 |
56.221 |
|
Q68 |
3.65 |
2.764 |
3.395 |
|
Q69 |
0.93 |
0.720 |
0.689 |
|
Q70 |
23.13 |
3.016 |
3.255 |
|
Q71 |
2.33 |
2.211 |
2.196 |
|
Q72 |
3.69 |
2.270 |
2.521 |
|
Q73 |
1.40 |
1.743 |
2.068 |
|
Q74 |
37.27 |
34.956 |
29.475 |
|
Q75 |
11.85 |
5.517 |
5.769 |
|
Q76 |
3.37 |
2.364 |
2.730 |
|
Q77 |
1.30 |
1.112 |
1.141 |
|
Q78 |
152.21 |
12.058 |
14.874 |
|
Q79 |
4.49 |
3.766 |
4.449 |
|
Q80 |
3.56 |
1.696 |
1.770 |
|
Q81 |
0.64 |
0.390 |
0.409 |
|
Q82 |
0.75 |
0.655 |
0.735 |
|
Q83 |
0.15 |
0.085 |
0.216 |
|
Q84 |
0.24 |
0.221 |
0.234 |
|
Q85 |
2.78 |
1.151 |
1.512 |
|
Q86 |
2.59 |
0.345 |
0.364 |
|
Q87 |
78.17 |
10.557 |
11.300 |
|
Q88 |
6.90 |
9.081 |
9.688 |
|
Q89 |
2.61 |
0.918 |
1.058 |
|
Q90 |
0.64 |
0.569 |
0.787 |
|
Q91 |
0.15 |
0.135 |
0.114 |
|
Q92 |
0.20 |
0.118 |
0.127 |
|
Q93 |
7.53 |
3.977 |
4.413 |
|
Q94 |
3.49 |
1.746 |
2.109 |
|
Q95 |
29.57 |
27.629 |
25.971 |
|
Q96 |
1.49 |
1.844 |
2.062 |
|
Q97 |
8.49 |
3.341 |
3.674 |
|
Q98 |
1.09 |
0.938 |
0.865 |
|
Q99 |
2.37 |
1.503 |
1.516 |
|
SUM |
1321.757 |
645.424 |
622.214 |
