it would be nice if users would post their performance on a standard dataset to help us to choose the right hardware and help to discover performance or configurations problems.
anyway here some numbers of my configuration on a view joining the flights data with airports and carriers data
i am assuming your first time is with all data on disks
number of records: 123534969
loading time from csv: 168241 ms
CPU 3600 ms
GPU 3030 ms
CPU: between 214 and 293 ms
GPU: between 55 and 145 ms (with pascal gaming cards you cant fix the P-State so the frequencies changes a lot)
NVIDIA GTX 1080ti
CUDA cores 3584
GPU Memory 11GB
Memory Interface 352 bit
Memory Bandwidth 484 GB/sec
Anyway i guess you are not using all your cpu processing power if you are on default parameters creating tables, because for what i know ( i hope to dont be wrong) the columns are fragmented with “extents” of 32 millions and a cpu core process this chunk of data in an exclusive manner; so with 117m or records you are using just 4 cores, and with 7/14/21 just one.
You gpu isnt exactly powerful, but you could try to fix the P-State. Here is a link