TPC-DS Test Result

This test tested the query performance of TPC-DS 1 TB datasets in both the storage-compute coupled and storage-compute decoupled architectures. A total of 99 queries were performed. The total query time for the storage-compute coupled architecture was 622.21 seconds, compared to 645.42 seconds for the decoupled architecture. Learn more information in the following table.

**Table 1** TPC-DS test result
TPC-DS Query	8.3.0	9.1.0.210
-	Storage-compute coupled architecture (s)	Storage-compute coupled architecture (s)	Storage-compute decoupled architecture (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