topic Re: Data Model Resident Loads in QlikView

Data Model Resident Loads

schneider2037 — Wed, 25 Nov 2020 16:16:04 GMT

I'm working through overnight performance hits on the QV Server.

One item that I'm seeing is that our Data Model QVWs often have dozens or more of Resident loads against underlying QVDs as well as large SQL outputs from our ERP.

QUESTION: do all of these Resident loads within each QVW really have that much of a performance impact?

Thanks! Jonathan

Re: Data Model Resident Loads

MK_QSL — Tue, 17 Apr 2018 13:54:31 GMT

You can try both

Resident Load

Preceding Load

to find out with one is more effective for performance point of view.

Read below blog..

The Cost of Preceding Load | Qlikview Cookbook

Re: Data Model Resident Loads

ychaitanya — Tue, 17 Apr 2018 13:59:11 GMT

i would suggest to load the data from QVDs wherever possible than compared to using the Resident Loads

and implement exists() with combination of INLINE to implement filters

Thanks

Re: Data Model Resident Loads

schneider2037 — Tue, 17 Apr 2018 14:29:03 GMT

Git it. Thanks for the helpful link!

Re: Data Model Resident Loads

schneider2037 — Tue, 17 Apr 2018 14:30:32 GMT

Gotcha. It also looks like we're fully reloading transaction facts - which is crazy. Why reload transactions that haven't changed since 2012 every night!? Looking to switch the underlying models to incremental. Methinks here lies the major part of the overnight performance hits.

Thanks!