Set vs Let in script. What gets loaded during Partial Reload?
I am doing some thinking out loud to see if anyone else has experienced this.
I am curious on what gets executed during a partial reload. I added a new QVD for some benchmark data to import to my current QVW. I just wanted to load this data, so I did an ADD Load and used Partial Reload to import it to my data tables.
It seems that the SET statements in my load script were executed, but the LET statements were not or they did not give me the right results as they were dependent on other load statements. That kind of makes sense, but I would like some clarification of what actually gets executed on a partial reload. I know that it is any load statement with ADD or Replace in front of it, but what else does or does not get loaded.
My LET statements are important as the results of them are used in calculations in objects. It would seem that would be an important consideration to know ahead of time, so I don't accidentally put my end users in a bind.
In my case, the LET values are now null, since they did not get executed properly as part of the loads that were not executed on the partial reload.
In my experience I have seen both LET and SET are executed on Partial Reload. Like you said the issue could be related to tables which are used in the LET which are not getting executed during Partial Reload.
Thanks for your feedback. I agree with both of you. I use LET statements in my calendar table that are not executed when I do a partial reload. It would seem that a partial reload should only be used in development and testing rather than any production situation.