topic Re: optimize load script in QlikView

optimize load script

Anonymous — Tue, 22 Dec 2015 09:33:31 GMT

How could replace where condition in the following script in order to optimize loading script ?

Vente:
LOAD PrixUnitaireArticle,
PrixArticleHT,
PrixRevientTTC,
MargeHT,
MargeTTC,
ValeurRevientHT,
ValeurRevientTTC,
ValeurMargeHT,
ValeurMargeTTC,
PrixVenteHT,
N°tickets,
EAN,
[Code Caisse],
[Code Site],
[Prix de vente TTC],
Quantité,
[Date Time],
Promo,
[Code Article],
[Code Structure],
Alimentaire,
[Prix de Revient],
TVA,
DivKey,
ID,
DateOfHire,
nbrClient,
KeyVenteSite,
code4 ,
datecol,
Date(Date#(Date,'YYYY-MM-DD'),'YYYYMMDD') as Date ,
Date#(Date,'YYYY-MM-DD') as DateTest ,
ApplyMap('MapComp', datecol&[Code Site]&code4 , 'O') as Comp,
ApplyMap('MapCasse', [Code Site]&[Code Article]&Date(Date#(Date,'YYYY-MM-DD'),'YYYYMMDD') ,0) as QuantiteCasse,
ApplyMap('MapAjust', [Code Site]&[Code Article]&Date(Date#(Date,'YYYY-MM-DD'),'YYYYMMDD') ,0) as QuantiteAjust
FROM
E:\QVD\QVD\VenteFull.qvd
(qvd)
Where (isnull([Code Article]) = 0) and (isnull([Code Structure]) = 0) and (isnull([Prix de Revient])=0);

Re: optimize load script

roger_stone — Tue, 22 Dec 2015 09:41:08 GMT

The WHERE clause isn't the problem, it's the functions that you're using that will cause the load to be unoptimised.

Re: optimize load script

tresB — Tue, 22 Dec 2015 09:43:12 GMT

Replacing the where clause alone would not make this load an optimized one. Because you are applying some functions on the loaded field and modifying the values, and this modifications are causing it to make an unoptimzed one. Read this blog by stevedark : http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/ for more in details.

Re: optimize load script

Anonymous — Tue, 22 Dec 2015 09:43:14 GMT

what you mean about functions ?

Re: optimize load script

Peter_Cammaert — Tue, 22 Dec 2015 09:44:09 GMT

You could first load the entire QVD in memory, and then process/filter whatever you need. Loading from disk in an unoptimized way is often much slower than loading straightaway, and processing in RAM.

Re: optimize load script

roger_stone — Tue, 22 Dec 2015 09:45:24 GMT

DATE(), DATE#() and APPLYMAP() are all functions.