I see it does no longer use Synthetic keys (so that's definately a + :-)), but in that case I still need to do some kind of reload of all of the data (BUT according to you, it should be definately a lot faster), right?
Re: Avoid reloading table using 'resident' function
I gave that serveral tries, but QlikView can't recognize the variable coming from the other table...
If I look at the age function you are mentioning, it takes more than 2 parameters... Is that correct? Further I don't see the exact difference between the two examples you are showing... I suppose one is done in the script and the other one is done in the cloud itself? (this last one is not an option for 36M rows :-)).
Ps: I just created a QVD with the source data, to stop fooling arround with inline tables (as the actual data will also be fed from a QVD).