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