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: 100 - Q22 Seconds < Lower Is Better a . 15.62 |==================================================================== b . 15.30 |=================================================================== 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 - Q20 Seconds < Lower Is Better a . 57.66 |==================================================================== b . 56.28 |================================================================== 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 - Q18 Seconds < Lower Is Better a . 128.13 |=================================================================== b . 124.87 |================================================================= 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 - Q16 Seconds < Lower Is Better a . 13.42 |==================================================================== b . 13.20 |=================================================================== 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 - Q14 Seconds < Lower Is Better a . 51.29 |==================================================================== b . 50.80 |=================================================================== 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 - Q12 Seconds < Lower Is Better a . 66.35 |==================================================================== b . 63.17 |================================================================= 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 - Q10 Seconds < Lower Is Better a . 66.99 |==================================================================== b . 65.45 |================================================================== 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 - Q08 Seconds < Lower Is Better a . 72.40 |==================================================================== b . 72.32 |==================================================================== 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 - Q06 Seconds < Lower Is Better a . 44.72 |==================================================================== b . 44.60 |==================================================================== 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 - Q04 Seconds < Lower Is Better a . 63.46 |==================================================================== b . 62.61 |=================================================================== 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 - Q02 Seconds < Lower Is Better a . 11.50 |==================================================================== b . 11.56 |==================================================================== 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 - Geometric Mean Of All Queries Seconds < Lower Is Better a . 52.10 |==================================================================== b . 51.04 |=================================================================== 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: 50 - Q21 Seconds < Lower Is Better a . 128.89 |=================================================================== b . 129.67 |=================================================================== 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 - Q19 Seconds < Lower Is Better a . 25.31 |=================================================================== b . 25.80 |==================================================================== 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 - Q17 Seconds < Lower Is Better a . 58.29 |=================================================================== b . 59.48 |==================================================================== 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 - Q15 Seconds < Lower Is Better a . 23.35 |==================================================================== b . 23.47 |==================================================================== 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 - Q13 Seconds < Lower Is Better a . 11.81 |=================================================================== b . 12.01 |==================================================================== 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 - Q11 Seconds < Lower Is Better a . 6.12172890 |=============================================================== b . 5.90383053 |============================================================= 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 - Q09 Seconds < Lower Is Better a . 45.67 |==================================================================== b . 44.24 |================================================================== 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 - Q07 Seconds < Lower Is Better a . 33.64 |==================================================================== b . 33.19 |=================================================================== 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 - Q05 Seconds < Lower Is Better a . 36.86 |================================================================== b . 37.95 |==================================================================== 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 - Q03 Seconds < Lower Is Better a . 36.09 |==================================================================== b . 35.12 |================================================================== 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 - Q01 Seconds < Lower Is Better a . 25.41 |==================================================================== b . 25.54 |==================================================================== 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: 10 - Q22 Seconds < Lower Is Better a . 2.17159438 |=============================================================== b . 2.08513021 |============================================================ 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 - Q20 Seconds < Lower Is Better a . 6.33807818 |=============================================================== b . 6.10991335 |============================================================= 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 - Q18 Seconds < Lower Is Better a . 12.66 |==================================================================== b . 12.63 |==================================================================== 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 - Q16 Seconds < Lower Is Better a . 2.27786120 |============================================================= b . 2.33905911 |=============================================================== 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 - Q14 Seconds < Lower Is Better a . 5.44949262 |=============================================================== b . 5.33258104 |============================================================== 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 - Q12 Seconds < Lower Is Better a . 6.23972781 |============================================================== b . 6.35672379 |=============================================================== 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 - Q10 Seconds < Lower Is Better a . 7.10535590 |=============================================================== b . 7.15195179 |=============================================================== 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 - Q08 Seconds < Lower Is Better a . 7.33203538 |=============================================================== b . 7.11410093 |============================================================= 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 - Q06 Seconds < Lower Is Better a . 4.43370914 |=============================================================== b . 4.36986017 |============================================================== 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 - Q04 Seconds < Lower Is Better a . 6.57711776 |=============================================================== b . 6.30942202 |============================================================ 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 - Q02 Seconds < Lower Is Better a . 2.25004848 |=============================================================== b . 2.11009860 |=========================================================== 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 - Geometric Mean Of All Queries Seconds < Lower Is Better a . 5.75490740 |=============================================================== b . 5.75735680 |=============================================================== 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: 1 - Q21 Seconds < Lower Is Better a . 3.59445604 |=============================================================== b . 3.61977267 |=============================================================== 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 - Q19 Seconds < Lower Is Better a . 0.69395985 |=============================================================== b . 0.66654742 |============================================================= 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 - Q17 Seconds < Lower Is Better a . 1.46219754 |=============================================================== b . 1.44221175 |============================================================== 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 - Q15 Seconds < Lower Is Better a . 0.77650092 |=============================================================== b . 0.77098012 |=============================================================== 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 - Q13 Seconds < Lower Is Better a . 0.79169283 |=============================================================== b . 0.76867819 |============================================================= 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 - Q11 Seconds < Lower Is Better a . 0.62522713 |=============================================================== b . 0.61058140 |============================================================== 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 - Q09 Seconds < Lower Is Better a . 1.99082625 |============================================================== b . 2.03148746 |=============================================================== 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 - Q07 Seconds < Lower Is Better a . 1.41287736 |=============================================================== b . 1.39594340 |============================================================== 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 - Q05 Seconds < Lower Is Better a . 1.43073702 |============================================================= b . 1.48697722 |=============================================================== 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 - Q03 Seconds < Lower Is Better a . 1.38435690 |=============================================================== b . 1.36037207 |============================================================== 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 - Q01 Seconds < Lower Is Better a . 2.15049744 |=============================================================== b . 2.13585591 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Geometric Mean Of All Queries Seconds < Lower Is Better a . 1.07551776 |=============================================================== b . 1.06830837 |===============================================================