Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

qvd optimized

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

2 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

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
Partner - Creator II
Partner - Creator II

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.