topic Re: Optimized Load at Presentation layer in QlikView

Optimized Load at Presentation layer

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

What is the meaning of optimized load at presentation layer? how it is done?

I only knows that optimized load is linked with QVDs but we create QVD in 2nd layer (Load and Transform) not at third layer

Re: Optimized Load at Presentation layer

Gysbert_Wassenaar — Tue, 05 Jul 2016 15:13:14 GMT

If you create qvd files that don't need any transformations in the load script of the presentation layer qlikview documents then you can make sure these qvd files are loaded with optimized load statements. If that happens then the data from the qvd file is read very very fast. See this blog post: http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Re: Optimized Load at Presentation layer

johnw — Tue, 05 Jul 2016 23:49:49 GMT

Just to make sure this is clear, the optimized load is when you read from a QVD, not when you create a QVD. So if your third layer is the QVW that has the all the charts in it, then that's where you'd ideally have optimized QVD loads. That should be practical since the second layer has already transformed the data, as you'd expect then to only need to load it as is without further transformation into the final QVW. I'm kind of just repeating what Gysbert said.

Re: Optimized Load at Presentation layer

marcus_sommer — Wed, 06 Jul 2016 05:56:14 GMT

There is another kind of loading data into a report which could be considered as optimized - the binary load as a third or maybe fourth layer of a data-architecture with generators --> datamodels --> reports.

- Marcus