I am attempting to improve the performance of a particular load script by ensuring QVD Loads are optimised.
Load Script as follows:
The following code ensures optimized load.
LET OrgId = 81;
LOAD * INLINE
WHERE EXISTS (OrgId);
The following code does not use optimized load when naming the fields individually. There are no calculations or other tranformations that would cause this to be an unoptimized load as far as I understand.
Normally the above should work. Just put this load into a complete new qvw without any other code and try it again. I assume it will work then and this means that any other stuff within your other qvw prevents the optimized loading.
I never noticed such behaviour before but I could imagine that some outside-logics in regard of a load-statement might enforce a processing of the data, for example NULL-variables like NULLASVALUE or BUFFER statements and probably some other rarely used options more.