hi @Jeon Woohyuck , my runtimes are linear on the same are using for testing Into the attach the queries runtime, memory allocation and - output Regards ------------------------------ Candido Dessanti Dba Crismatica consulting Rome ----------- ...
Oh, Sorry. that log is cold cache, but the value I wrote is the time value after running the query about 5 times. ------------------------------ Jeon Woohyuck [[Unknown]] ------------------------------
Hi @Patrick Erdelt I have 3 gpu's in this machine so I used this set up for my sharding DROP TABLE IF EXISTS PART; CREATE TABLE PART ( P_PARTKEY BIGINT, P_NAME TEXT ENCODING DICT, P_MFGR TEXT ENCODING DICT, P_BRAND TEXT ENCODING DICT, P_TYPE ...
Hi Thanks for your continued exploration of OmniSci @Patrick Erdelt Could you share the precise CREATE table statements you used to build your test tables for the above result? In parallel I will test this locally to see if i can see the difference ...