topic qvd optimized in QlikView

qvd optimized

ilanbaruch — Tue, 16 Jun 2015 09:03:25 GMT

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

Re: qvd optimized

jvitantonio — Tue, 16 Jun 2015 09:10:17 GMT

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.

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

Re: qvd optimized

sgrice — Tue, 16 Jun 2015 09:20:07 GMT

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.