Tests for a future article. AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and NVIDIA NV174 8GB on Ubuntu 23.10 via the Phoronix Test Suite.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2312041-PTS-TPCHSPAR10
tpch sparky,
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Geometric Mean Of All Queries",
Lower Results Are Better
"a",1.0530077,1.08718557,1.08636001
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q01",
Lower Results Are Better
"a",2.19629478,2.13822651,2.11697102
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q02",
Lower Results Are Better
"a",1.21764815,1.15072227,1.15015495
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q03",
Lower Results Are Better
"a",1.3501581,1.31444609,1.4884665
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q04",
Lower Results Are Better
"a",1.22668672,1.19325328,1.2987119
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q05",
Lower Results Are Better
"a",1.42514873,1.41139185,1.45567048
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q06",
Lower Results Are Better
"a",0.53062624,0.53816241,0.53127539
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q07",
Lower Results Are Better
"a",1.37764847,1.47393477,1.38704884
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q08",
Lower Results Are Better
"a",1.1836015,1.18193007,1.15280807
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q09",
Lower Results Are Better
"a",2.03004789,1.97516334,1.96726751
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q10",
Lower Results Are Better
"a",1.26345849,1.25417328,1.28264952
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q11",
Lower Results Are Better
"a",0.61222285,0.63085324,0.63260531
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q12",
Lower Results Are Better
"a",1.01763821,1.10824633,1.04760349
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q13",
Lower Results Are Better
"a",0.77376121,0.81304783,0.78826946
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q14",
Lower Results Are Better
"a",0.73406506,0.7315625,0.75039881
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q15",
Lower Results Are Better
"a",0.75899869,0.80919307,0.76131099
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q16",
Lower Results Are Better
"a",0.75358438,0.77523649,0.79798305
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q17",
Lower Results Are Better
"a",1.4310832,1.44281065,1.51269877
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q18",
Lower Results Are Better
"a",1.70468032,1.8866142,1.77664375
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q19",
Lower Results Are Better
"a",0.66403109,0.66347533,0.75437313
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q20",
Lower Results Are Better
"a",1.06726682,1.12001276,1.03682566
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q21",
Lower Results Are Better
"a",3.68116236,3.53287387,3.56933188
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q22",
Lower Results Are Better
"a",0.55491805,0.64197189,0.66649067
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Geometric Mean Of All Queries",
Lower Results Are Better
"a",5.77782964,5.74477445,5.7421181
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q01",
Lower Results Are Better
"a",6.10102224,6.37445593,6.45822144
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q02",
Lower Results Are Better
"a",2.17696404,2.24230099,2.3308804
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q03",
Lower Results Are Better
"a",7.38125944,7.50333977,7.55843496
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q04",
Lower Results Are Better
"a",6.72347212,6.54496908,6.46291208
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q05",
Lower Results Are Better
"a",7.99139929,7.99990368,7.7268548
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q06",
Lower Results Are Better
"a",4.33903837,4.50938606,4.452703
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q07",
Lower Results Are Better
"a",6.58642769,6.60867262,7.04760265
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q08",
Lower Results Are Better
"a",7.39514828,7.16356754,7.43739033
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q09",
Lower Results Are Better
"a",9.02489758,9.47705173,9.07773304
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q10",
Lower Results Are Better
"a",7.02083111,7.1329689,7.16226768
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q11",
Lower Results Are Better
"a",1.8394556,1.78050911,1.77189195
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q12",
Lower Results Are Better
"a",6.21971655,6.36615419,6.1333127
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q13",
Lower Results Are Better
"a",3.10191345,2.97243857,2.99336839
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q14",
Lower Results Are Better
"a",5.44812298,5.38522816,5.51512671
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q15",
Lower Results Are Better
"a",5.09153223,4.92353725,4.91934443
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q16",
Lower Results Are Better
"a",2.24512291,2.34215569,2.24630499
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q17",
Lower Results Are Better
"a",11.97730446,11.74473095,11.76730156
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q18",
Lower Results Are Better
"a",12.64678764,12.63332462,12.71170616
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q19",
Lower Results Are Better
"a",5.11212015,5.21306992,5.28018284
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q20",
Lower Results Are Better
"a",6.45358706,6.30061436,6.26003313
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q21",
Lower Results Are Better
"a",23.49271202,23.33612823,23.40080643
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q22",
Lower Results Are Better
"a",2.19580364,2.12581015,2.19316936
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Geometric Mean Of All Queries",
Lower Results Are Better
"a",25.26297398,25.52266387,26.25304356
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q01",
Lower Results Are Better
"a",25.75147629,25.14642525,25.33990097
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q02",
Lower Results Are Better
"a",6.85491991,6.67020512,7.04612064
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q03",
Lower Results Are Better
"a",35.17115784,36.35507584,36.75504303
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q04",
Lower Results Are Better
"a",30.4841404,30.77358246,32.14824295
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q05",
Lower Results Are Better
"a",36.31697845,36.94516754,37.32919693
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q06",
Lower Results Are Better
"a",22.15290833,22.03516197,22.17160034
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q07",
Lower Results Are Better
"a",33.1083374,33.53642273,34.2780571
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q08",
Lower Results Are Better
"a",34.89097595,36.88422775,37.06839371
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q09",
Lower Results Are Better
"a",43.10791397,46.92593384,46.96193314
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q10",
Lower Results Are Better
"a",32.9316597,33.05718231,33.21179199
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q11",
Lower Results Are Better
"a",6.22420311,6.05676937,6.08421421
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q12",
Lower Results Are Better
"a",31.71048927,32.06625748,33.34850311
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q13",
Lower Results Are Better
"a",11.58704662,11.72056103,12.11430931
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q14",
Lower Results Are Better
"a",25.9065609,25.30893135,25.71100235
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q15",
Lower Results Are Better
"a",23.38890266,23.2083149,23.44227219
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q16",
Lower Results Are Better
"a",6.05393982,6.11971903,7.45334435
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q17",
Lower Results Are Better
"a",57.67092514,58.40205765,58.80842972
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q18",
Lower Results Are Better
"a",61.69762421,62.91657257,64.43848419
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q19",
Lower Results Are Better
"a",25.36552429,25.20725632,25.35295677
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q20",
Lower Results Are Better
"a",28.47455406,28.77289772,28.99834061
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q21",
Lower Results Are Better
"a",126.85092163,128.89625549,130.93640137
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q22",
Lower Results Are Better
"a",8.0435257,7.89843893,8.32830048
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Geometric Mean Of All Queries",
Lower Results Are Better
"a",51.97516291,52.31560493,52.01610209
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q01",
Lower Results Are Better
"a",49.55869675,49.06517792,48.91469574
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q02",
Lower Results Are Better
"a",11.70918465,11.72239113,11.06416321
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q03",
Lower Results Are Better
"a",67.53987122,69.22199249,70.04586792
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q04",
Lower Results Are Better
"a",64.44932556,63.4384346,62.48404694
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q05",
Lower Results Are Better
"a",72.26158905,77.11595154,76.31450653
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q06",
Lower Results Are Better
"a",44.56490707,44.80373764,44.79172516
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q07",
Lower Results Are Better
"a",66.0870285,68.8299408,68.4970932
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q08",
Lower Results Are Better
"a",69.24459076,74.22711182,73.73912048
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q09",
Lower Results Are Better
"a",98.85330963,108.43795776,106.65171051
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q10",
Lower Results Are Better
"a",67.06652069,67.61518097,66.29856873
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q11",
Lower Results Are Better
"a",12.60770321,12.34300423,12.06919956
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q12",
Lower Results Are Better
"a",66.26058197,66.36030579,66.42933655
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q13",
Lower Results Are Better
"a",24.14678383,22.09478569,22.21329689
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q14",
Lower Results Are Better
"a",50.95786667,51.88183594,51.02999115
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q15",
Lower Results Are Better
"a",46.68780518,46.99573517,46.97710037
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q16",
Lower Results Are Better
"a",13.49190331,13.20802498,13.56103134
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q17",
Lower Results Are Better
"a",122.6654129,123.55755615,122.89700317
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q18",
Lower Results Are Better
"a",128.48199463,128.58744812,127.33338165
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q19",
Lower Results Are Better
"a",50.53050613,50.85875702,50.75653458
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q20",
Lower Results Are Better
"a",57.48120499,57.92304611,57.56697083
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q21",
Lower Results Are Better
"a",255.44631958,259.50570679,257.55764771
"b",
"Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q22",
Lower Results Are Better
"a",15.69903851,15.62133026,15.53166294
"b",