Concatenating two fields as a join taking too long to load

[D19PAL]

Hi Guys,

I was left joining these two tables via ID = ID and it was taking 7 minutes to load. Now i need to add Date to ID to make the join and It's taking an extra 23 mins to load, 30 mins in total, is that normal? or is there a better and more efficient way to do it? 

FactTemp:

NoConcatenate

Load

    (order_id & '|' & email) as KEY,*;

LOAD

            ID,  

    order_id,

    email,

Date1,

AutoNumber(ID & '|' & date(floor(Date1)))  as inv_del_key

FROM *******.qvd   ;

LIB CONNECT TO '**********';

left join (FactTemp)

LOAD

AutoNumber(ID & '|' & date(floor(Date)))  as inv_del_key,

Date,

TEST_FIELD;

sql

SELECT ID,

            Date,

            TEST_FIELD

FROM `***************`;

[rbartley]

Hi,

Have you tried creating the second table first without joining it so that it creates the key and then performing the join rather than doing both at the same time?  I'm not sure exactly how qlik processes the joins, but it's worth a try.