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
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.
a:
Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: 2000GB Samsung SSD 980 PRO 2TB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: NVIDIA NV174 8GB, Audio: NVIDIA GA104 HD Audio, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411
OS: Ubuntu 23.10, Kernel: 6.7.0-060700rc2daily20231127-generic (x86_64), Desktop: GNOME Shell 45.1, Display Server: X Server 1.21.1.7 + Wayland, Display Driver: nouveau, OpenGL: 4.3 Mesa 24.0~git2311260600.945288~oibaf~m (git-945288f 2023-11-26 mantic-oibaf-ppa), Compiler: GCC 13.2.0 + LLVM 16.0.6, File-System: ext4, Screen Resolution: 3840x2160
b:
Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: 2000GB Samsung SSD 980 PRO 2TB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: NVIDIA NV174 8GB, Audio: NVIDIA GA104 HD Audio, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411
OS: Ubuntu 23.10, Kernel: 6.7.0-060700rc2daily20231127-generic (x86_64), Desktop: GNOME Shell 45.1, Display Server: X Server 1.21.1.7 + Wayland, Display Driver: nouveau, OpenGL: 4.3 Mesa 24.0~git2311260600.945288~oibaf~m (git-945288f 2023-11-26 mantic-oibaf-ppa), Compiler: GCC 13.2.0 + LLVM 16.0.6, File-System: ext4, Screen Resolution: 3840x2160
Apache Spark TPC-H 3.5
Scale Factor: 1 - Geometric Mean Of All Queries
Seconds < Lower Is Better
a . 1.07551776 |===============================================================
b . 1.06830837 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q01
Seconds < Lower Is Better
a . 2.15049744 |===============================================================
b . 2.13585591 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q02
Seconds < Lower Is Better
a . 1.17284179 |==============================================================
b . 1.18847537 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q03
Seconds < Lower Is Better
a . 1.38435690 |===============================================================
b . 1.36037207 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q04
Seconds < Lower Is Better
a . 1.23955063 |=============================================================
b . 1.28710282 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q05
Seconds < Lower Is Better
a . 1.43073702 |=============================================================
b . 1.48697722 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q06
Seconds < Lower Is Better
a . 0.53335468 |===============================================================
b . 0.53715831 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q07
Seconds < Lower Is Better
a . 1.41287736 |===============================================================
b . 1.39594340 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q08
Seconds < Lower Is Better
a . 1.17277988 |===============================================================
b . 1.12742186 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q09
Seconds < Lower Is Better
a . 1.99082625 |==============================================================
b . 2.03148746 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q10
Seconds < Lower Is Better
a . 1.26676043 |==============================================================
b . 1.28957009 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q11
Seconds < Lower Is Better
a . 0.62522713 |===============================================================
b . 0.61058140 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q12
Seconds < Lower Is Better
a . 1.05782934 |===============================================================
b . 1.06473088 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q13
Seconds < Lower Is Better
a . 0.79169283 |===============================================================
b . 0.76867819 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q14
Seconds < Lower Is Better
a . 0.73867546 |=============================================================
b . 0.76540375 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q15
Seconds < Lower Is Better
a . 0.77650092 |===============================================================
b . 0.77098012 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q16
Seconds < Lower Is Better
a . 0.77560131 |===============================================================
b . 0.71527606 |==========================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q17
Seconds < Lower Is Better
a . 1.46219754 |===============================================================
b . 1.44221175 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q18
Seconds < Lower Is Better
a . 1.78931276 |===============================================================
b . 1.77616072 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q19
Seconds < Lower Is Better
a . 0.69395985 |===============================================================
b . 0.66654742 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q20
Seconds < Lower Is Better
a . 1.07470175 |===========================================================
b . 1.15345001 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q21
Seconds < Lower Is Better
a . 3.59445604 |===============================================================
b . 3.61977267 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 1 - Q22
Seconds < Lower Is Better
a . 0.62112687 |===============================================================
b . 0.60666102 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Geometric Mean Of All Queries
Seconds < Lower Is Better
a . 5.75490740 |===============================================================
b . 5.75735680 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q01
Seconds < Lower Is Better
a . 6.31123320 |===============================================================
b . 6.14967728 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q02
Seconds < Lower Is Better
a . 2.25004848 |===============================================================
b . 2.11009860 |===========================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q03
Seconds < Lower Is Better
a . 7.48101139 |===============================================================
b . 7.33041668 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q04
Seconds < Lower Is Better
a . 6.57711776 |===============================================================
b . 6.30942202 |============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q05
Seconds < Lower Is Better
a . 7.90605259 |===============================================================
b . 7.57603073 |============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q06
Seconds < Lower Is Better
a . 4.43370914 |===============================================================
b . 4.36986017 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q07
Seconds < Lower Is Better
a . 6.74756765 |==============================================================
b . 6.81029701 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q08
Seconds < Lower Is Better
a . 7.33203538 |===============================================================
b . 7.11410093 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q09
Seconds < Lower Is Better
a . 9.19322745 |============================================================
b . 9.60581684 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q10
Seconds < Lower Is Better
a . 7.10535590 |===============================================================
b . 7.15195179 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q11
Seconds < Lower Is Better
a . 1.79728555 |==========================================================
b . 1.94165230 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q12
Seconds < Lower Is Better
a . 6.23972781 |==============================================================
b . 6.35672379 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q13
Seconds < Lower Is Better
a . 3.02257347 |===============================================================
b . 2.90124249 |============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q14
Seconds < Lower Is Better
a . 5.44949262 |===============================================================
b . 5.33258104 |==============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q15
Seconds < Lower Is Better
a . 4.97813797 |===============================================================
b . 5.01319218 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q16
Seconds < Lower Is Better
a . 2.27786120 |=============================================================
b . 2.33905911 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q17
Seconds < Lower Is Better
a . 11.83 |====================================================================
b . 11.80 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q18
Seconds < Lower Is Better
a . 12.66 |====================================================================
b . 12.63 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q19
Seconds < Lower Is Better
a . 5.20179097 |===============================================================
b . 5.22612810 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q20
Seconds < Lower Is Better
a . 6.33807818 |===============================================================
b . 6.10991335 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q21
Seconds < Lower Is Better
a . 23.41 |====================================================================
b . 23.30 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 10 - Q22
Seconds < Lower Is Better
a . 2.17159438 |===============================================================
b . 2.08513021 |============================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Geometric Mean Of All Queries
Seconds < Lower Is Better
a . 25.68 |===================================================================
b . 25.90 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q01
Seconds < Lower Is Better
a . 25.41 |====================================================================
b . 25.54 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q02
Seconds < Lower Is Better
a . 6.85708189 |===============================================================
b . 6.84252167 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q03
Seconds < Lower Is Better
a . 36.09 |====================================================================
b . 35.12 |==================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q04
Seconds < Lower Is Better
a . 31.14 |====================================================================
b . 31.28 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q05
Seconds < Lower Is Better
a . 36.86 |==================================================================
b . 37.95 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q06
Seconds < Lower Is Better
a . 22.12 |===================================================================
b . 22.31 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q07
Seconds < Lower Is Better
a . 33.64 |====================================================================
b . 33.19 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q08
Seconds < Lower Is Better
a . 36.28 |====================================================================
b . 34.89 |=================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q09
Seconds < Lower Is Better
a . 45.67 |====================================================================
b . 44.24 |==================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q10
Seconds < Lower Is Better
a . 33.07 |===================================================================
b . 33.63 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q11
Seconds < Lower Is Better
a . 6.12172890 |===============================================================
b . 5.90383053 |=============================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q12
Seconds < Lower Is Better
a . 32.38 |====================================================================
b . 32.26 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q13
Seconds < Lower Is Better
a . 11.81 |===================================================================
b . 12.01 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q14
Seconds < Lower Is Better
a . 25.64 |==================================================================
b . 26.26 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q15
Seconds < Lower Is Better
a . 23.35 |====================================================================
b . 23.47 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q16
Seconds < Lower Is Better
a . 6.54233440 |==========================================================
b . 7.12703753 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q17
Seconds < Lower Is Better
a . 58.29 |===================================================================
b . 59.48 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q18
Seconds < Lower Is Better
a . 63.02 |====================================================================
b . 62.97 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q19
Seconds < Lower Is Better
a . 25.31 |===================================================================
b . 25.80 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q20
Seconds < Lower Is Better
a . 28.75 |===================================================================
b . 29.01 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q21
Seconds < Lower Is Better
a . 128.89 |===================================================================
b . 129.67 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 50 - Q22
Seconds < Lower Is Better
a . 8.09008837 |=============================================================
b . 8.37519741 |===============================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Geometric Mean Of All Queries
Seconds < Lower Is Better
a . 52.10 |====================================================================
b . 51.04 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q01
Seconds < Lower Is Better
a . 49.18 |====================================================================
b . 49.31 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q02
Seconds < Lower Is Better
a . 11.50 |====================================================================
b . 11.56 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q03
Seconds < Lower Is Better
a . 68.94 |====================================================================
b . 69.43 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q04
Seconds < Lower Is Better
a . 63.46 |====================================================================
b . 62.61 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q05
Seconds < Lower Is Better
a . 75.23 |====================================================================
b . 74.52 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q06
Seconds < Lower Is Better
a . 44.72 |====================================================================
b . 44.60 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q07
Seconds < Lower Is Better
a . 67.80 |===================================================================
b . 68.33 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q08
Seconds < Lower Is Better
a . 72.40 |====================================================================
b . 72.32 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q09
Seconds < Lower Is Better
a . 104.65 |===================================================================
b . 102.81 |==================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q10
Seconds < Lower Is Better
a . 66.99 |====================================================================
b . 65.45 |==================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q11
Seconds < Lower Is Better
a . 12.34 |====================================================================
b . 12.13 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q12
Seconds < Lower Is Better
a . 66.35 |====================================================================
b . 63.17 |=================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q13
Seconds < Lower Is Better
a . 22.82 |====================================================================
b . 22.06 |==================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q14
Seconds < Lower Is Better
a . 51.29 |====================================================================
b . 50.80 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q15
Seconds < Lower Is Better
a . 46.89 |====================================================================
b . 46.55 |====================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q16
Seconds < Lower Is Better
a . 13.42 |====================================================================
b . 13.20 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q17
Seconds < Lower Is Better
a . 123.04 |===================================================================
b . 119.17 |=================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q18
Seconds < Lower Is Better
a . 128.13 |===================================================================
b . 124.87 |=================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q19
Seconds < Lower Is Better
a . 50.72 |====================================================================
b . 50.32 |===================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q20
Seconds < Lower Is Better
a . 57.66 |====================================================================
b . 56.28 |==================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q21
Seconds < Lower Is Better
a . 257.50 |===================================================================
b . 251.07 |=================================================================
Apache Spark TPC-H 3.5
Scale Factor: 100 - Q22
Seconds < Lower Is Better
a . 15.62 |====================================================================
b . 15.30 |===================================================================