qvd optimized

[ilanbaruch]

Hi all,

my model based on 9 QVD's, 4 of them connected with a link table \ key table

I notice that when I add the key field to connect tables via link table (THE_DATE&'|'&CAMPAIGN_NAME&'|'&AD_GROUP&'|'&PLACEMENT AS G_PLACEMENT), Script Execution is going very slow and the QVD's are not optimized.

is there any way to optimize these 4 QVD's?

Thanks,

ilan

[jvitantonio]

Hi ilan,

QVD load won't be optimized if you make any modifications to your load statement. The only function you can use is the "as" keyword to rename your fields.

I would recommend 2 things:

1) You can create this concatenated key when you create your QVD. you can then directly load these 4 QVDs in an optimized way.

OR

2) First LOAD all 4 QVDS, and then create the keys and join once these QVDs are in memory. This will make things faster as everything is in RAM.

Juan

[sgrice]

String concatenation is VERY slow and you are also losing optimized loading [qlikview super fast load].

If you are just wanting a unique key then use

autonumberhash256(THE_DATE,CAMPAIGN_NAME,AD_GROUP,PLACEMENT) AS G_PLACEMENT,

This is many times quicker that concatenate string but will still not use optimized loading.

Be Aware:-This will give you a unique key but the key will be different after every reload. But the same within a reload for the same values.