Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Optimized Load at Presentation layer

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

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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/


talk is cheap, supply exceeds demand
johnw
Champion III
Champion III

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.

marcus_sommer

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