# TPC-DS测试结果
本测试主要包括使用存算一体和存算分离两种部署架构下，TPC-DS 1T规模数据集的开箱查询性能，共99个查询。存算一体查询总耗时为645.42s，存算分离查询总耗时为622.21s。详细结果见下表。
表1TPC-DS测试结果 
| **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     |